Kuisa uye Kudzingesa SQL Server Data Kubva Mutsara Wemirayiro NeBcp

Bcp ndiyo nzira inokurumidza kuwana dheta mu database

Bhokisi reBucp (bcp) reMicrosoft SQL Server rinokupa iwe unokwanisa kuisa maverengi makuru emarekhodi kubva pamutsara wemirairo. Mukuwedzera pakuva chinhu chakakosha chemutambo-line aficionados, bcp utility isimboti ine simba kune avo vanoedza kuisa data mune imwe nhepfenyuro yeSQL Server kubva mukati mefaji yematch kana imwe nzira yekuita. Pane nzira dzakawanda dzekuwana deta mu database, asi bcp ndiyo inokurumidza kana yakagadzirirwa nemararamiro akanaka.

bcp Syntax

Izwi rekutanga rekushandisa bcp nderokuti:

bcp

apo nharo dzinotora zvinotevera:

• Table_name ndiro zita rakakwana rinofanirwa patafura. Semuenzaniso, unogona kushandisa zvinyorwa.dbo.fruit kuti uise zvinyorwa mumatafura emichero ane mudzidzi wepa database mumabhuku ekutsvaga.
• Nhungamiro inoratidza kana iwe uchida kuisa ("mumutungamiri") kana kutumira kunze ("kunze" murayiridzo) data.
• File_name ndiyo nzira yakazara yefaira. Somuenzaniso, unogona kutumira faira C: \ zvibereko \ inventory.txt.
• Zvokusarudza zvinokubvumira kuti utaure mitsara yemabasa akawanda. Somuenzaniso, unogona kutsanangura nhamba yepamusoro yekanganiso yakabvumirwa ne--m chisarudzo. Iwe unogona kushandisawo--sarudzo yekutsanangura fomu yefaira ye XML. Tsvaga maMicrosoft mabcp zvinyorwa zveruzhinji.

bcp Kukosha Muenzaniso

Kuti uzviise pamwe chete, fungidzira iwe une tafura yezvigadzirwa mumabhuku ako ezvinyorwa uye iwe unoda kutumira zvese zvinyorwa kubva pane zvakanyorwa faira zvakachengetwa paibhuku rako rakaoma mune iyo database. Iwe unoshandisa bcp iri murairo wekutsvaga:

bcp inventory.dbo.fruit mu "C: \ zvibereko \ inventory.txt" -c-T

Izvi zvinogadzira zvinotevera:

C: \> bcp inventory.dbo.fruit mu "C: \ zvibereko \ inventory.txt" -c-T Kutanga kopi ... 36 mitsetse yakakopiwa. Network packet usayizi (bytes): 4096 Clock Time (ms.) Zvose: 16 Avhareji: (2250.00 mitsara paese.) C: \>

Iwe unogona kunge wakacherechedza zvitsva zviviri zvitsva pane iyo mutsara wemirairo. I-c sarudzo inotsanangura kuti faira yefaira yefaira yekutumira ichava taboti-yakagadzirirwa mavara nerekodhi imwe neimwe mumutsara mutsva. I-T sarudzo inotsanangura kuti bcp inofanira kushandisa Windows kuvimbiswa kuti iungane kune database.

bcp Export Example

Iwe unogona kutumira dhamusi kubva kune d database yako ne bcp nekushandura mutungamiri webasa kubva "mukati" kusvika "kunze." Somuenzaniso, unogona kudhura zviri mukati metafura yemichero kune faira faira nemurairo unotevera:

bcp inventory.dbo.fruit kunze "C: \ zvibereko \ inventory.txt" -c-T

Heuno maitiro ayo anotarisa pamutsara wemirairo:

C: \> bcp inventory.dbo.fruits kunze "C: \ zvibereko \ inventory.txt" -c-T Kutanga kopi ... 42 mitsetse yakopihwa. Network packet size (bytes): 4096 Clock Time (ms.) Zvose: 1 Avhareji: (42000.00 mitsara pamasese.) C: \>

Izvo zvose zviripo kune bcp murairo. Iwe unogona kushandisa mutemo uyu kubva mukati memafuta ekutsvaga kana mamwe mapurogiramu ane ruzivo rwemutsetse weDOS wemirairo kuti uite zvinoshandiswa kutumira nekutsvaga kwemashoko kubva kuScL Server database yako.