Indlela yokungenisa nokuthumela iiDatha ngeSQL Server 2012

Ukusebenzisa i-Wizard yokungenisa nokuThengisa

I-SQL Server yokungenisa kunye ne-Export Wizard ikuvumela ukuba ungenise kalula ulwazi kwiziko leSQL Server 2012 ukusuka kuyo nayiphi na imithombo yolwazi elandelayo:

• Microsoft Excel
• Microsoft Access
• Iifayile ezicwangcisiweyo
• Olunye ulwazi lweSQL Server

IWizard yakha iiphakheji ze-SQL Server Integration Services (SSIS) nge-interface-friendly friendly interface.

Ukuqala i-Wizard yeSport and Export Wizard

Qala i-Wizard yeSport and Export Wizard ngqo kwi-Start menu kwisistimu eneSQL Server 2012 sele ifakiwe. Ngaphandle koko, ukuba usuqhuba iSquL Server Management Studio, landela la manqanaba ukuqalisa idilesi:

1. Vula i- SQL Server Management Studio .
2. Nika iinkcukacha zeseva ofuna ukulawula kunye negama lomsebenzisi kunye nephasiwedi efanelekileyo xa ungasebenzisi i- Windows Authentication .
3. Chofoza ukuxhuma ukuxhuma kwiseva esuka kwi-SSMS.
4. Nqakraza ngegama lenkcukacha yedatha ofuna ukuyisebenzisa kwaye ukhethe Ukungenisa iDatha kwimenyu yeMisebenzi .

Ukungenisa iDatha kwiSQL Server 2012

I-SQL Server yokungenisa kunye ne-Export Wizard ikukhokela ngenkqubo yokungenisa idatha ukusuka kuyo nayiphi na imithombo yolwazi ekhoyo kwiSquL Server database. Lo mzekelo uhamba ngeenkqubo zokungenisa ulwazi loqhagamshelwano oluvela kuMicrosoft Excel ukuya kwisiseko seSQL Server, ukuzisa idatha kwifayile yefowuni ye Excel kwifayile entsha ye-SQL Server database.

Nantsi indlela:

1. Vula i- SQL Server Management Studio .
2. Nika iinkcukacha zeseva ofuna ukulawula kunye negama lomsebenzisi kunye nephasiwedi efanelekileyo xa ungasebenzisi i-Windows Authentication.
3. Chofoza ukuxhuma ukuxhuma kwiseva esuka kwi-SSMS.
4. Nqakraza ngegama lenkcukacha yedatha ofuna ukuyisebenzisa kwaye ukhethe Ukungenisa iDatha kwimenyu yeMisebenzi . Chofoza Okulandelayo .
5. Khetha iMicrosoft Excel njengomthombo wedatha (kulo mzekelo).
6. Cofa iqhosha lokuDlulisa , khangela ifayile yedilesi.xls kwikhompyutheni yakho, kwaye nqakraza Vula .
7. Qinisekisa ukuba umgca Wokuqala unebhokisi yamagama ebhokisi ehlolwe. Chofoza Okulandelayo .
8. Kukhetho khetha Isikrini sokuya , khetha iSiveri yomNyango weSQL Server njengomthombo wedatha.
9. Khetha igama lomncedisi ofuna ukuba ungenise idatha ukusuka kwiBhokisi leNgcaciso yegama lomSebenzi.
10. Qinisekisa ulwazi lokuqinisekisa kwaye ukhethe ukhetho oluhambelana nomoya wakho we-SQL Server.
11. Khetha igama lenkcazelo ecacileyo ofuna ukuyifaka idatha ukusuka kwi-Ibhokisi lokuhlaselwa phantsi kweDatabase. Chofoza Okulandelayo , uze uklikhazele Okulandelayo kwakhona ukuba wamukele Ikopi yedatha ukusuka kwelinye okanye ngaphezulu kweetafile okanye inketho yokujonga kwiCacify Table Copy okanye Umbuzo weskrini.

1. Kwibhokisi ehlayo ye- Destination , khetha igama letafile ekhoyo kwiziko ledatha yakho okanye uthayiphe igama letafile entsha ofuna ukuyilungisa. Kulo mzekelo, le spreadsheet ye-Excel isetyenzisiweyo ukudala itafile entsha ebizwa ngokuba "oonxibelelwano." Chofoza Okulandelayo .
2. Cofa iqhosha lokugqiba ukuqaqa phambili kwisikrini sokuqinisekisa.
3. Emva kokuphononongwa kwezenzo ze-SSIS eziza kwenzeka, cofa iqhosha lokugqiba ukugqiba ukungenisa.

Idatha yokuThumela kwiSQL Server 2012

I-SQL Server yokungenisa kunye ne-Export Wizard ikukhokela ngenkqubo yokuthumela idatha esuka kwisiseko sakho seSQL Server kunoma iyiphi ifomathi esekelwe. Lo mzekelo uhamba ngeenkqubo zokuthatha ulwazi loqhagamshelwano oluthunyelwe kumzekelo wangaphambili kwaye ulithumela kwifayile efayili.

Nantsi indlela:

1. Vula i- SQL Server Management Studio .
2. Nika iinkcukacha zeseva ofuna ukulawula kunye negama lomsebenzisi kunye nephasiwedi efanelekileyo xa ungasebenzisi i-Windows Authentication.
3. Chofoza ukuxhuma ukuxhuma kwiseva esuka kwi-SSMS.
4. Nqakraza ngegama lenkcukacha yedatha ofuna ukuyisebenzisa kwaye ukhethe Ukuthumela idatha kwiMenyu yemiSebenzi. Chofoza Okulandelayo .
5. Khetha Umxhasi weNgcaciso lweSQL Server njengomthombo wakho wedatha.
6. Khetha igama lomncedisi ofuna ukukhupha idatha ukusuka kwiBhokisi loNgcoliso lwegama lomSebenzi .
7. Qinisekisa ulwazi lokuqinisekisa kwaye ukhethe ukhetho oluhambelana nomoya wakho we-SQL Server.
8. Khetha igama lenkcukacha ecacileyo ofuna ukuthumela idatha ukusuka kwibhokisi ehlayo yeDatabase . Chofoza Okulandelayo .
9. Khetha Indawo yeFayile yePlayati esuka kwibhokisi yokuhlahla.
10. Nika umgca wefayile kunye negama eliphela kwi ".txt" kwibhokisi yegama lefayile (umzekelo, "C: \ Users \ mike \ Documents \ contact.txt"). Chofoza Okulandelayo , uze ulandele kwakhona ukuba wamukele Ikopi yedatha ukusuka kwelinye okanye ngaphezulu kweetafile okanye inketho yokujonga.

1. Cofa Okulandelayo kabini ngaphezulu, uze uqedele ukuqaqa phambili kwisikrini sokuqinisekisa.
2. Emva kokuphononongwa kwezenzo ze-SSIS eziza kwenzeka, cofa iqhosha lokugqiba ukugqiba ukungenisa.