Ukungenisa nokuthumela ii-SQL Server Data ukusuka kumgca wokuLawula ngeBcp

I-Bcp yindlela ekhawulezayo yokufumana idatha kwi-database

Umyalelo wenkohlakalo (bcp) umyalelo we- Microsoft SQL Server unikezela ngokukwazi ukufaka inani elikhulu lamarekhodi ngqo kumgca womyalelo. Ukongezelela ekubeni yinto ewusizo ye-line-line aficionados, isevisi ye-bcp iyithuluzi elinamandla kulabo abafuna ukufaka idatha kwiziko leSQL Server ukusuka kwifayile yeetch okanye enye indlela yohlelo. Kukho iindlela ezininzi zokufumana idatha kwiziko ledatha, kodwa i-bcp ihamba ngokukhawuleza xa isetyenzisiweyo kunye neerameters ezifanelekileyo.

Bcp Syntax

I-syntax eyintloko yokusebenzisa i-bcp yile:

bcp

apho iingxoxo zithatha ixabiso elilandelayo:

• I-Table_name igama elifanelekileyo elifanelekileyo letafile. Ngokomzekelo, ungasebenzisa i-inventory.dbo.truits ukufaka iirekhodi kwitafile zeziqhamo ezithathwe ngumnikazi weenkcukacha kwi-database yolwazi.
• Isikhokelo sibonisa ukuba ufuna ukungenisa ("kwinqanaba") okanye ukuthumela ngaphandle ("ngaphandle") idatha.
• Ifayile_nomdla yindlela epheleleyo kwifayile. Umzekelo, ungangenisa ifayile C: \ izithelo \ inventory.txt.
• Okukhethwa kukho kukuvumela ukuba uchaze iiparitha ze-operation bulk. Umzekelo, ungacacisa inani eliphambili lempazamo evunyelwe nge--m. Ungasebenzisa kwakhona ukhetho lwe--x ukuchaza ifom yefayile ye-XML. Qhagamshelana noxwebhu lwe-bcp lwe-Microsoft uluhlu olupheleleyo.

bcp Ukungenisa umzekelo

Ukuyibeka ndawonye, ​​cinga ukuba unetafile yeziqhamo kwi- database yakho yolwazi kwaye ufuna ukungenisa zonke iirekhodi kwifayili yombhalo ogcinwe kwi-hard drive yakho kwi-database. Uza kusebenzisa okulandelayo i-syntax yomyalelo we-bcp:

bcp inventory.dbo.fruit kwi "C: \ izithelo \ inventory.txt" -c -T

Oku kuvelisa oku kulandelayo:

C: \> bcp inventory.dbo.fruit kwi "C: \ izithelo \ inventory.txt" -c -T Ukuqala ikopi ... 36 imigqa ikopi. Ubungakanani bepakethe yenethiwekhi (bytes): 4096 Ixesha lexesha lexesha (ms.) Inani lilonke: 16 Umyinge: (2250.00 imiqolo ngomzuzwana.) C: \>

Usenokuba uqaphele iindlela ezimbini ezitsha kwiloo mgca womyalelo. I -cc inkcazo ichaza ukuba ifomathi yefayili yefayile yokungenisa iya kuba itek-edibeneyo yombhalo kunye nerekhodi nganye kumgca omtsha. I -T inketho ibonisa ukuba i-bcp kufuneka isebenzise ukuqinisekiswa kwe-Windows ukuxhuma kwi-database.

bcp Export Example

Ungathumela idatha kwi-database yakho nge-bcp ngokutshintsha isikhokelo somsebenzi ukususela "kwi" ukuya "ngaphandle." Ngokomzekelo, unokulahla iziqulatho zeziqulatho zeziqhamo kwifayili yombhalo ngomyalelo olandelayo:

bcp inventory.dbo.fruit ngaphandle "C: \ izithelo \ inventory.txt" -c -T

Nantsi indlela ekubukeka ngayo kumgca womyalelo:

C: \> bcp inventory.dbo.fruit ngaphandle "C: \ izithelo \ yokusungula.txt" -c -T Ukuqala ikopi ... 42 imigqa ikopi. Ubungakanani bepakethe yenethiwekhi (bytes): 4096 Ixesha lokuvala (ms.) Inani lilonke: 1 Umyinge: (42000.00 imigqa ngomzuzwana.) C: \>

Kukho konke okukhoyo kumyalelo we-bcp. Ungasebenzisa lo myalelo ukusuka kwiifayile zeetch okanye ezinye iinkqubo zokufikelela kumgca we-DOS umyalelo wokuzenzekelayo ukuthumela nokuthumela idatha kwiSquL Server yakho.