I-Bcp yindlela esheshayo yokuthola idatha ku-database
Umyalo we-bulk (bcp) we- Microsoft SQL Server unikeza ikhono lokufaka inani elikhulu lamarekhodi ngokuqondile emgqeni wokulayela. Ngaphandle kokuba ithuluzi eliwusizo lamakholi we-line-command, ibhukwana le-bcp iyithuluzi elinamandla kulabo abafuna ukufaka idatha kwi-database ye- SQL Server kusuka ngaphakathi kwefayela le-batch noma enye indlela yohlelo. Kunezindlela eziningi zokuthola idatha ku-database, kepha i-bcp iyona esheshayo uma isethiwe ngemingcele efanele.
I-syntax ye-bcp
I-syntax eyisisekelo yokusebenzisa i-bcp yile:
bcplapho izingxabano zithatha amanani alandelayo:
- I-Table_name igama elifanelekayo letafula. Isibonelo, ungasebenzisa i-inventory.dbo.fruits ukufaka amarekhodi etafuleni lezithelo eziphethwe ngumnikazi we-database ku-database yolwazi.
- Ukuqondiswa kubonisa ukuthi ufuna ukungenisa ("ekuqondeni") noma ukuthumela ("out" isiqondiso) idatha.
- Ifayela_ifayela liyindlela egcwele efayeleni. Isibonelo, ungangenisa ifayela C: \ izithelo \ yokusungula.txt.
- Izinketho zikuvumela ukuba ucacise imingcele ye-operation enkulu. Isibonelo, ungacacisa inani eliphezulu lamaphutha avunyelwe nge--m inketho. Ungasebenzisa futhi inketho ye--x ukuze ucacise ifomethi yefayela le-XML. Bheka imibhalo ye-bcp ye-Microsoft yohlu olugcwele.
Isibonelo sokungenisa i-bcp
Ukukubeka ndawonye, cabanga ukuthi unetafula lezithelo ku- database yakho yokusungula futhi ufuna ukungenisa wonke amarekhodi avela efayeleni yombhalo egcinwe kwi-hard drive yakho kuleyo database. Ungasebenzisa i-syntax ye-bcp yomyalo elandelayo:
okusungulwa kwe-bcp.dbo.fruit ku "C: \ izithelo \ yokusungula.txt" -c-TLokhu kuveza okukhiphayo okulandelayo:
C: \> bcp yokusungula.dbo.fruit ku "C: \ izithelo \ yokusungula.txt" -c -T Ukuqala ikhophi ... 36 imigqa ikhophiwe. Usayizi wepakethe yenethiwekhi (bytes): 4096 Isikhathi sewashi (ms.) Isiqalo: 16 Isilinganiso: (2250.00 imigqa ngesekhondi.) C: \>Ungase uqaphele izinketho ezimbili ezintsha kulowo mlayini womyalo. I -c inketho icacisa ukuthi ifomethi yefayela yefayela lokungenisa kuyoba umbhalo wethebhu-okhishwe ngamarekhodi ngamunye emgqeni omusha. I -T inketho icacisa ukuthi i-bcp kufanele isebenzise ukuqinisekiswa kwe-Windows ukuxhuma ku-database.
Bcp Export Isibonelo
Ungathumela idatha kusuka ku-database yakho nge-bcp ngokushintsha ukuqondisa kokusebenza kusuka ku- "kuya" kuya "ngaphandle." Ngokwesibonelo, ungalahla okuqukethwe kwethebula lesithelo kwifayela lokubhala ngomyalo olandelayo:
isakhiwo se-bcp.dbo.fruit ngaphandle "C: \ izithelo \ yokusungula.txt" -c-TNakhu ukuthi lokho kubukeka kanjani emgqeni womyalo:
C: \> bcp yokusungula.dbo.fruit ngaphandle "C: \ izithelo \ yokusungula.txt" -c -T Ukuqala ikhophi ... 42 imigqa ikhophiwe. Usayizi wepakethe yenethiwekhi (bytes): 4096 Isikhathi sewashi (ms.) Isamba: 1 Isilinganiso: (42000.00 imigqa ngesekhondi.) C: \>Yilokho konke okukhona kumyalo we-bcp. Ungasebenzisa lo myalo kusuka ngaphakathi kwamafayela we-batch noma ezinye izinhlelo zokufinyelela kulayini lomyalo we-DOS ukuze wenze ngokuzenzakalelayo ukungenisa nokuthumela idatha kusuka ku-SQL Server database yakho.