Bcp ke tsela e potlakileng haholo ea ho fumana data ho database
Taelo ea boholo-holo (bcp) ea Microsoft SQL Server e fana ka matla a ho kenya lenane le lengata la litlaleho ka ho toba molaong oa taelo. Ntle le ho ba sesebelisoa se molemo bakeng sa line-line ea li-command, bcp utility ke sesebelisoa se matla ho ba batlang ho kenngoa boitsebiso boitsebisong ba SQL Server ho tloha ka har'a faele ea batch kapa mokhoa o mong oa lenaneo. Ho na le litsela tse ngata tsa ho fumana boitsebiso boitsebisong, empa bcp ke ea potlako ha e thehiloe ka mekhahlelo e nepahetseng.
Syntax ea bcp
Tlhaloso ea motheo ea ho sebelisa bcp ke:
bcpmoo likhang li nkang litekanyetso tse latelang:
- Table_name ke lebitso le tšoanelehang la tafole. Ka mohlala, u ka 'na ua sebelisa lisebelisoa.dbo.fruit hore u kenye litlaleho tafoleng ea litholoana e nang le mong'a ditshebeletso ka boitsebiso ba lisebelisoa.
- Tataiso e bontša hore na u batla ho kenya ("ka" tataiso) kapa ho romela lintlha tsa "tsoa" tataiso).
- Fom_name ke tsela e feletseng ho file. Ka mohlala, u ka kenya file F: \ litholoana \ inventory.txt.
- Lintho tse u lumellang li u lumella hore u hlalose meeli ea mosebetsi o mongata. Ka mohlala, o ka bonts'a palo e kholo ea liphoso tse lumelloa ka -m kgetho. U ka boela ua sebelisa -x kgetho ho hlakisa mofuta oa faele oa XML. Sheba lintlha tsa bcp tsa Microsoft bakeng sa lenane le feletseng.
Mohlala oa Bohlokoa oa Bcp
E le hore u li behe hammoho, nahana hore u na le tafole ea litholoana hothathamong ea hau ea lisebelisoa 'me u batla ho kenya litlaleho tsohle ho tloha ho fomoro e ngotsoeng ho bolokiloe ka thata ho eona. U tla sebelisa syntaxe ea taelo ea bcp e latelang:
lisebelisoa tsa bcp.dbo.fruit "C: \ litholoana \ inventory.txt" -c-TSena se hlahisa lintho tse latelang:
C: \> bcp inventory.dbo. litholoana "C: \ litholoana \ inventory.txt" -c-T Ho qala kopi ... 36 mela e kopitsoe. Boima ba packet ea mefuta (bytes): 4096 Nako ea ho Clock (ms.) Kakaretso: 16 Karolelano: (2250.00 mela ka ts'ebetso.) C: \>E ka 'na eaba u hlokometse mekhoa e mecha e mecha ea molaetsa oa taelo. The -c khetho e bolela hore fomati ea faele ea faele ea ho kenya e tla be e ngotsoe tab-delimited le rekoto e 'ngoe le e' ngoe mocheng o mocha. The -T kgetho e totobatsa hore bcp e lokela ho sebelisa Windows ho netefatsa ho hokahanya database.
bcp Export Mohlala
O ka romela dintlha ho tswa ho database ya hau ka bcp ka ho fetola tataiso ea tshebetso ho tswa ho "ho" ho "ho" tsoa. "Ka mohlala, o ka tlosa dikahare tsa tafoleng ya litholoana ho faele ya tokomane ka taelo e latelang:
lisebelisoa tsa bcp.dbo.fruit ntle ho "C: \ litholoana \ inventory.txt" -c-TMona ke kamoo ho shebahalang molaong oa taelo:
C: \> bcp inventory.dbo.fruits ntle "C: \ litholoana \ inventory.txt" -c-T Ho qala kopi ... 42 mela e kopitsoe. Boima ba packet ea network (bytes): 4096 Nako ea nako ea nako (ms.) Kakaretso: 1 Karolelano: (42000.00 mela ka ts'ehetso.) C: \>Ke sona sohle seo ho leng taelo ea bcp. U ka sebelisa taelo ena ho tloha ka har'a lifaele tsa batch kapa mananeo a mang a nang le phihlelo ea molaetsa oa taelo ea DOS ho etsa hore ho kenngoe le ho romela lits'ebeletso tsa data ho tsoa Sonneteng ea SQL Server.