Nzira Yokutenga uye Kutumira Data Ne SQL Server 2012

Kushandisa Import and Export Wizard

SQL Server Import uye Export Wizard inokubvumira kuti nyore nyore kutumira mashoko muSQL Server 2012 database kubva kune ipi inotevera inotora data:

• Microsoft Excel
• Microsoft Access
• Flat files
• Rimwe SQL Server database

Iyo wizard inovaka SQL Server Integration Services (SSIS) nepakimiji kuburikidza ne-user-friendly graphical interface.

Kutanga SQL Server Kuisa uye Kubuditsa Wizard

Tanga SQL Server Kuisa uye Kubuditsa Wizard zvakananga kubva Pakutanga menyu pane imwe nzira ine SQL Server 2012 inenge yaiswa. Zvimwe, kana uchitotanga SQL Server Management Studio, tevera matanho aya kutanga wizard:

1. Vhura SQL Server Management Studio .
2. Ipa tsanangudzo yevhavha raunoda kutarisira uye zita rekushandisa rakakodzera nephasiwedi kana iwe usingashandisi Windows Authentication .
3. Dhinda Connect kuti uungane kune server kubva SSMS.
4. Kungofa-tanga pazita re database iyo iwe unoda kushandisa uye sarudza Dhadha Dzebasa kubva kumenyu yeMabasa .

Kuendesa Dhina kuSQL Server 2012

SQL Server Inotora uye Inotumira Wizard inokurongedza kuburikidza nekugadzira kwekutumira data kubva kune imwe yenzvimbo yako iripo yezvinyorwa kune database yeSQL Server. Uyu muenzaniso unofamba kuburikidza nekutumira mazano ekubatana kubva kuMicrosoft Excel kuenda kune imwe nhepfenyuro yeSQL Server, kuunza data kubva muenzaniso yekutsvakurudza ye Excel kutafura itsva ye database yeSQL Server.

Heino nzira:

1. Vhura SQL Server Management Studio .
2. Ipa tsanangudzo yevhavha raunoda kutarisira uye zita rekushandisa rakakodzera nephasiwedi kana iwe usingashandisi Windows Authentication.
3. Dhinda Connect kuti uungane kune server kubva SSMS.
4. Kungofa-tanga pazita re database iyo iwe unoda kushandisa uye sarudza Dhadha Dzebasa kubva kumenyu yeMabasa . Dhinda Kutevera .
5. Sarudza Microsoft Excel senzira yedhesi (nokuda kwemuenzaniso uyu).
6. Dzvanya pfupa reKutsvaga , tsvaga iyo address.xls file pakombiyuta yako, uye ovha Open .
7. Chengetedza kuti Mutsara Wokutanga une makoromita mazita mabhokisi anoongororwa. Dhinda Kutevera .
8. Pamusoro peSarudza nzvimbo yekuenda kune chinyorwa, sarudza SQL Server Native Client sezviri kuwanikwa.
9. Sarudza zita revhare iwe waunoda kutumira data kubva kuSeva Name Name rezasi-bhokisi.
10. Chengetedza uhwu hunozivikanwa uye sarudza zvisarudzo zvinoenderana neSQL Server yekutendesa mamiriro.
11. Sarudza zita renzvimbo yakachengetwa yaunoda kutumira data kubva kuDhesi rezasi rebhokisi. Dzvanya Zvichizoitika , uye chengetedza Zvakare zvakare kugamuchira Ikopa data kubva kune rimwe kana kupfuura mamwe matafura kana maonero ekutaura paChirangaridzo Table Copy kana Query screen.

1. MuBhokisi rezasi rebhokisi, sarudza zita retafura iripo mune yako dhesi kana kuti nyora zita retafura itsva yaunoda kusika. Mumuenzaniso uyu, iyi spreadsheet yeExcel yakashandiswa pakugadzira tafura itsva inonzi "vanobatana." Dhinda Kutevera .
2. Dzvanya bhodhi raKupedzisa kuti usvikire mberi kune chinyorwa chekuongorora.
3. Mushure mekuongorora zviito zveSSSIS zvichaitika, chovha Bhodhi rekupedzisa kupedzisa kupinda.

Kubuditsa Dhina kubva kuSQL Server 2012

SQL Server Inotora uye Inotumira Wizard inokutungamirira iwe kuburikidza nekugadzirisa kwekutumira data kubva kuSquL Server yako yekodhi kune imwe nzira yakatsigirwa. Uyu muenzaniso unokufambisa kuburikidza nekutora hutano hwekufambisa iwe waunyoresa muenzaniso wekare uye uchiutumira kune imwe gorofa file.

Heino nzira:

1. Vhura SQL Server Management Studio .
2. Ipa tsanangudzo yevhavha raunoda kutarisira uye zita rekushandisa rakakodzera nephasiwedi kana iwe usingashandisi Windows Authentication.
3. Dhinda Connect kuti uungane kune server kubva SSMS.
4. Kungofa-kanda pazita re database iyo iwe unoda kushandisa uye sarudza Dhinda Data kubva kumenyu yeMabasa . Dhinda Kutevera .
5. Sarudza SQL Server Mutevedzeri weKutevedzeri semuzinda wako wedhesi.
6. Sarudza zita revhare iwe waunoda kutumira data kubva muZita reZita rakaderera pasi.
7. Chengetedza uhwu hunozivikanwa uye sarudza zvisarudzo zvinoenderana neSQL Server yekutendesa mamiriro.
8. Sarudza zita renzvimbo yakachengetwa yaunoda kutumira dheta kubva muBhokisi reDhesi rezasi. Dhinda Kutevera .
9. Sarudza Flat Files Destination kubva kuBaodzorwa pasi-bhokisi bhokisi.
10. Ipa faira nzira uye zita rinopera mu ".txt" muFichi Name Name text box (somuenzaniso, "C: \ Users \ mike \ Documents \ contacts.txt"). Dzvanya Zvichizoitika , uye Zvadaro zvakare kugamuchira Kopi data kubva kune rimwe kana kupfuura matafura kana maonero ekusarudza.

1. Dzvanya Kutevera kaviri zvakare, Ezvo Gumisa kusvetuka mberi kusvika pane chinyorwa chekuongorora.
2. Mushure mekuongorora zviito zveSSSIS zvichaitika, chovha Bhodhi rekupedzisa kupedzisa kupinda.