Ịbubata na mbupụ Data Data SQL Site na Nweta Iwu na Bcp

Bcp bụ ụzọ kachasị mfe iji nweta data n'ime nchekwa data

Nchịkọta nnukwu akwụkwọ (bcp) nke Microsoft SQL Server na- enye gị ikike ịtinye ọtụtụ ederede kpọmkwem site na akara iwu ahụ. Na mgbakwunye na ịghọ ngwá ọrụ bara uru maka iwu-line aficionados, uru bcp bụ ngwá ọrụ dị ike nye ndị na-achọ itinye data n'ime data SQL Server site na faịlụ batch ma ọ bụ usoro mmemme ọzọ. Enwere otutu ụzọ iji nweta data n'ime nchekwa data, mana ọ bụ ngwa ngwa mgbe e guzobere ya na mpaghara nke ziri ezi.

pịa Syntax

Nkọwa isi maka iji bcp bụ:

bcp

ebe arụmụka na-agbaso ụkpụrụ ndị a:

• Aha aha_bụ bụ aha ruru eru nke tebụl. Dịka ọmụmaatụ, ị nwere ike iji inventory.dbo.fruits iji tinye ihe ndekọ n'ime mkpụrụ osisi nke onye nwe nchekwa data nwere na nchekwa data.
• Ntuziaka na- egosi ma ịchọrọ ịbubata ("na" ntụziaka) ma ọ bụ mbupụ ("si" ntụziaka ").
• File_name bụ ụzọ zuru ezu na faịlụ ahụ. Dịka ọmụmaatụ, ịnwere ike ibubata faịlụ C: \ fruit \ inventory.txt.
• Nhọrọ na- enye gị ohere ịkọwa parameters maka nnukwu ọrụ. Dịka ọmụmaatụ, ị nwere ike ezipụta ọnụ ọgụgụ kachasị nke njehie kwere na nhọrọ -m. Ị nwekwara ike iji nhọrọ -x iji kọwaa ụdị faịlụ XML. Gaa akwụkwọ Microsoft maka akwụkwọ zuru ezu.

bcp Bubata Ihe Nlereanya

Iji tinye ya niile, were ya na ị nwere table osisi na nchekwa data gị na ịchọrọ ịbịnye ihe ndekọ niile site na faịlụ ederede echekwara na draịvụ ike gị n'ime nchekwa data ahụ. Ị ga - eji usoro iwu bcp na - esonụ:

bcp inventory.dbo.fruits in "C: \ fruit \ inventory.txt" -c -T

Nke a na-emepụta mmepụta na-esonụ:

C: \> bcp inventory.dbo.fruits in "C: \ fruit \ inventory.txt" -c -Bido nbido ... 36 ahịrị e depụtaghachiri. Nkeji netwọk netwọk (bytes): 4096 Oge elekere (ms.) Ọnụ: 16 Nkezi: (2250.00 ahịrị kwa elekere.) C: \>

O nwere ike ịbụ na ị hụla nhọrọ abụọ ọzọ na akara ahụ. Nhọrọ nhọrọ -c na-ekwuputa na usoro faịlụ nke faịlụ mbubata ga-abụ ihe ederede ederede na listi ọ bụla na akara ọhụrụ. The-nhọrọ kwuru na bcp kwesịrị iji nyocha Windows iji jikọọ na nchekwa data.

bcp Export Example

Ị nwere ike mbupụ data sitere na nchekwa data gị ma gbanwee site na ịgbanwe ntuziaka nke ọrụ ahụ site na "na" iji "pụta." Dịka ọmụmaatụ, ị nwere ike iwepu ọdịnaya nke okpokoro mkpụrụ osisi na faịlụ ederede site na iwu:

bcp inventory.dbo.fruits out "C: \ fruit \ inventory.txt" -c -T

Nke a bụ otu esi elee akara iwu anya:

C: \> bcp inventory.dbo.fruits out "C: \ fruit \ inventory.txt" -c -Bido nbido ... 42 ahịrị edepụtara. Nkeji netwọk netwọk (bytes): 4096 Oge elekere (ms.) Ngụkọta: 1 Nkezi: (42000.00 ahịrị kwa elekere.) C: \>

Nke ahụ niile bụ iwu iwu. Ị nwere ike iji iwu a site na faịlụ batch ma ọ bụ mmemme ndị ọzọ na ịnweta akara iwu DOS iji mee ka mbubata na mbupu nke data site na SQL Server database gị.