Indlela yokungenisa nokuthumela idatha nge-SQL Server 2012

Ukusebenzisa i-Wizard Yokungenisa Nokuthumela

I-SQL Server Import and Export Wizard ikuvumela ukuthi ungene kalula ulwazi olugciniwe ku- SQL Server 2012 database kusuka kunoma yimiphi imithombo yedatha elandelayo:

• I-Microsoft Excel
• Ukufinyelela kwe-Microsoft
• Amafayili ama-Flat
• Enye imininingwane ye-SQL Server

IWizard yakha amaphakheji we-SQL Server Integration Services (SSIS) ngokusebenzisa isikhombimsebenzisi esibonakalayo somsebenzisi.

Ukuqala i-SQL Server Import and Export Wizard

Qala i-SQL Server Import and Export Wizard ngokuqondile kwimenyu yokuqala ekuqaleni kwesistimu ene-SQL Server 2012 kakade ifakiwe. Ngaphandle kwalokho, uma usuvele usebenzisa i-SQL Server Management Studio, landela lezi zinyathelo ukuze uqalise idijithi:

1. Vula SQL Server Management Studio .
2. Nikeza imininingwane yeseva ofuna ukuphatha kanye negama lomsebenzisi nephasiwedi efanele uma ungasebenzisi Windows Ukuqinisekiswa .
3. Chofoza okuthi Xhuma ukuxhuma kuseva kusuka ku-SSMS.
4. Chofoza ngakwesokudla egameni lesitatimende sedatha oyifunayo bese ukhetha Ukungenisa Idatha kwimenyu yemisebenzi.

Ukungenisa Idatha ku-SQL Server 2012

I-SQL Server Import and Export Wizard ikuqondisa ngenqubo yokungenisa idatha kusuka kunoma yimiphi imithombo yakho yedatha ekhona kwi-SQL Server database. Lesi sibonelo sihamba ngezinqubo zokungenisa ulwazi lokuxhumana oluvela kuMicrosoft Excel kuya ku-database ye-SQL Server, ukuletha idatha kusuka kwifomula ye-Excel yoxhumana nabo etafuleni elisha le-SQL Server database.

Nansi indlela:

1. Vula SQL Server Management Studio .
2. Nikeza imininingwane yeseva ofuna ukuphatha kanye negama lomsebenzisi nephasiwedi efanele uma ungasebenzisi Windows Ukuqinisekiswa.
3. Chofoza okuthi Xhuma ukuxhuma kuseva kusuka ku-SSMS.
4. Chofoza ngakwesokudla egameni lesitatimende sedatha oyifunayo bese ukhetha Ukungenisa Idatha kwimenyu yemisebenzi. Chofoza Okulandelayo .
5. Khetha i- Microsoft Excel njengomthombo wedatha (kulolu sibonelo).
6. Chofoza inkinobho Yedlulisa amehlo , thola ifayela lekheli.xls kwikhompyutha yakho, bese uchofoza u- Open .
7. Qinisekisa ukuthi umugqa Wokuqala unegama lamakholomu amagama ebhokisi. Chofoza Okulandelayo .
8. Esikrinini Khetha Isikrini sokuya , khetha iSiklayenti Somdabu SQL Server njengomthombo wedatha.
9. Khetha igama leseva ofuna ukuyifaka idatha kusuka ebhokisini le-Down Name phansi.
10. Qinisekisa ulwazi lokuqinisekisa bese ukhetha okukhethwa kukho okuhambisana nemodi yakho yokuqinisekisa ye-SQL Server.
11. Khetha igama lemininingwane ethize ofuna ukuyifaka idatha kusuka ebhokisini lokudonsela phansi leDatabase. Chofoza Okulandelayo , bese uchofoza Okulandelayo futhi wamukele idatha yeKopi kusuka kumathebula owodwa noma ngaphezulu noma okukhethwa kukho kokubuka ku-Specify Table Copy noma Umbuzo wesibuko.

1. Ebhokisini lokudonsa phansi le- Destination , khetha igama letafula elikhona ku-database yakho noma uthayiphe igama letafula elisha ofuna ukulidala. Kulesi sibonelo, le spreadsheet le-Excel isetshenziselwe ukwakha itafula elisha elibizwa ngokuthi "oxhumana nabo." Chofoza Okulandelayo .
2. Chofoza inkinobho yokuqeda ukweqa ngaphambi kwesikrini sokuqinisekisa.
3. Ngemuva kokubuyekeza izenzo ze-SSIS ezizokwenzeka, chofoza inkinobho yokuqedela ukuqedela ukungenisa.

Ukuthumela idatha kusuka ku-SQL Server 2012

I-SQL Server Import and Export Wizard ikuqondisa ngenqubo yokuthumela idatha kusuka ku-database yakho ye-SQL Server kunoma iyiphi ifomethi esekelwayo. Lesi sibonelo sikuhamba ngenqubo yokuthatha imininingwane yokuxhumana oyifakile kwisibonelo sangaphambilini futhi uyithumela efayeleni eliphambili.

Nansi indlela:

1. Vula SQL Server Management Studio .
2. Nikeza imininingwane yeseva ofuna ukuphatha kanye negama lomsebenzisi nephasiwedi efanele uma ungasebenzisi Windows Ukuqinisekiswa.
3. Chofoza okuthi Xhuma ukuxhuma kuseva kusuka ku-SSMS.
4. Chofoza ngakwesokudla egameni lesitatimende sedatha oyifunayo bese ukhetha Ukuthumela idatha kusuka kwimenyu yemisebenzi. Chofoza Okulandelayo .
5. Khetha iKlayenti YomNyango Yomphakathi We-SQL njengomthombo wakho wedatha.
6. Khetha igama leseva ofuna ukuthekelisa idatha kusuka ebhokisini le- Down Name phansi leSeva.
7. Qinisekisa ulwazi lokuqinisekisa bese ukhetha okukhethwa kukho okuhambisana nemodi yakho yokuqinisekisa ye-SQL Server.
8. Khetha igama le-database ethize ofuna ukuthekelisa idatha kusuka ebhokisini elidonsela phansi leDatabase. Chofoza Okulandelayo .
9. Khetha Indawo Yamafayela Asefulethini ukusuka ebhokisini elidonsela phansi le- Destination .
10. Nikeza indlela yefayela kanye negama eliphela ku- ".txt" ebhokisini lombhalo wegama lefayela (isibonelo, "C: \ Abasebenzisi \ mike \ Amadokhumenti \ contacts.txt"). Chofoza Okulandelayo , bese ulandela futhi ukwamukela idatha yeKopi kusuka kumathebula owodwa noma ngaphezulu noma okukhethwa kukho kokubuka .

1. Chofoza Okulandelayo kabili, bese uqeda ukweqa ngaphambi kwesikrini sokuqinisekisa.
2. Ngemuva kokubuyekeza izenzo ze-SSIS ezizokwenzeka, chofoza inkinobho yokuqedela ukuqedela ukungenisa.