Ana shigowa da Ana aikawa da SQL Server Data Daga Layin Jirgin Tare da Bcp

Bcp shine hanya mafi sauri don samun bayanai a cikin wani asusun

Dokar kyauta mai yawa (bcp) na Microsoft SQL Server tana ba ku damar da za a iya shigar da manyan fayiloli na ainihi daga layin umarni. Bugu da ƙari, kasancewa kayan aiki mai amfani ga layin afonionados, mai amfani da kayan aiki shine kayan aiki masu karfi ga waɗanda suke neman saka bayanai a cikin Database SQL Server daga cikin fayil ɗin tsari ko wasu hanyoyin da aka tsara. Akwai hanyoyi masu yawa don samun bayanai a cikin wani bayanai, amma bcp shine mafi sauri lokacin da aka kafa shi tare da sigogi na gaskiya.

bcp Syntax

Mahimmin rubutun don amfani da bcp shine:

bcp

inda muhawarar ke ɗaukar dabi'u masu biyowa:

• Sunan na Table_nomin shine sunan cikakken launi na tebur. Alal misali, zaku iya amfani da kaya na stock inventory.dbo.fruits don saka rubutun a cikin 'ya'yan itatuwa wanda mai mallakar mai mallakar ya mallaki kayan ajiya.
• Jagora yana nuna ko kuna so su shigo ("a" shugabanci) ko fitarwa ("fitar" jagora) bayanai.
• File_name shine cikakken hanyar zuwa fayil ɗin. Misali, zaka iya shigo da fayil C: \ 'ya'yan itace \ inventory.txt.
• Zaɓuka ba ka damar ƙayyade sigogi don babban aiki. Alal misali, za ka iya ƙayyade yawan adadin kurakurai da aka yarda tare da zaɓi -m. Kuna iya amfani da zaɓi -x don saka wani tsari na XML. A duba takardun bcp na Microsoft don cikakken jerin.

bcp Shigo da misali

Don sanya shi gaba ɗaya, kuyi tunanin kuna da ɗakunan 'ya'yan itatuwa a cikin kundin ajiyar ku kuma kuna so ku shigo da duk rubutun daga fayil ɗin da aka adana a kan rumbun kwamfutarka a cikin wannan asusun. Za ku yi amfani da wannan umarni mai ƙarfi na bcp:

bcp inventory.dbo.fruits a "C: \ 'ya'yan itace \ inventory.txt" -c -T

Wannan yana samar da kayan aiki na gaba:

C: \> bcp inventory.dbo.fruits in "C: \ 'ya'yan itace \ inventory.txt" -c-Farawa kwafi ... 36 layuka da aka kwafe. Girman fakitin hanyar sadarwa (bytes): 4096 Lokacin Lokaci (ms.) Ƙari: 16 Matsakaici: (2250.00 layuka da sec.) C: \>

Kuna iya lura da sabon zaɓi biyu a kan wannan umurnin. Zaɓin -c ya ƙayyade cewa tsarin fayil ɗin fayil ɗin shigo zai zama rubutun da ke cikin rubutu tare da kowane rikodin akan sabon layi. A-Zaɓin ya ƙayyade cewa bcp ya kamata yin amfani da Tantancewar Windows don haɗawa da asusun.

bcp Export Example

Zaka iya fitarwa bayanan daga kwamfutarka tare da bcp ta hanyar sauya jagorancin aiki daga "a" zuwa "fita." Misali, zaka iya zubar da abinda ke ciki na teburin 'ya'yan itace zuwa fayil din rubutu tare da umurnin mai biyowa:

bcp inventory.dbo.fruits daga "C: \ 'ya'yan itace \ inventory.txt" -c -T

Ga yadda wannan ya dubi layin umarni:

C: \> bcp inventory.dbo.fruits out "C: \ fruit \ inventory.txt" -c-Farawa kwafi ... 42 layuka kofe. Girman fakitin hanyar sadarwa (bytes): 4096 Lokacin Lokaci (ms.) Ƙari: 1 Tsarin: (42000.00 layuka da sec.) C: \>

Wannan duka yana da umarnin bcp. Kuna iya amfani da wannan umarni daga cikin fayilolin tsari ko wasu shirye-shirye tare da samun dama ga layin umarni na DOS don sarrafawa da shigo da fitarwa daga bayanan SQL Server.