Momwe Mungatulutsire ndi Kutumizira Dongosolo ndi SQL Server 2012

Pogwiritsa ntchito Wowonjezera ndi Kutumiza Wowonjezera

SQL Server Import ndi Export Wizard imakulolani kuti mulowetse chidziwitso ku SQL Server 2012 kuchokera kuzinthu zotsatirazi:

• Microsoft Excel
• Microsoft Access
• Mafayi apulati
• Mndandanda wina wa SQL Server

Wizara imamanga phukusi la SQL Server Integration Services (SSIS) kudzera mu mawonekedwe owonetsera ogwiritsira ntchito.

Kuyambitsa SQL Server Import ndi Export Wizard

Yambitsani SQL Server Import ndi Export Wizard mwachindunji kuchokera Quran menyu pa dongosolo lomwe SQL Server 2012 kale anaika. Mwinanso, ngati mwathamanga kale SQL Server Management Studio, tsatirani njira izi kuti muyambe wizard:

1. Tsegulani SQL Server Management Studio .
2. Perekani tsatanetsatane wa seva yomwe mukufuna kuigwiritsa ntchito ndi dzina loyenera ndi password ngati simukugwiritsa ntchito Windows Authentication .
3. Dinani Kulumikiza kuti mugwirizane ndi seva kuchokera ku SSMS.
4. Dinani pa dzina la deta zomwe mukufuna kugwiritsa ntchito ndikusankha Import Data kuchokera ku menyu Ntchito .

Kulowetsa Deta ku SQL Server 2012

SQL Server Import ndi Export Wizard ikukutsogolerani kudzera mukutumiza deta kuchokera kumalo anu onse omwe alipo deta kupita ku deta ya SQL Server. Chitsanzo ichi chikuyenda kudzera mukutumiza mauthenga okhudzana nawo kuchokera ku Microsoft Excel kupita ku SQL Server database, ndikubweretsa deta kuchokera kuchitsanzo cha Excel chojambulira mu tebulo latsopano la SQL Server.

Nazi momwemo:

1. Tsegulani SQL Server Management Studio .
2. Perekani tsatanetsatane wa seva yomwe mukufuna kuigwiritsa ntchito ndi dzina loyenera ndi password ngati simukugwiritsa ntchito Windows Authentication.
3. Dinani Kulumikiza kuti mugwirizane ndi seva kuchokera ku SSMS.
4. Dinani pa dzina la deta zomwe mukufuna kugwiritsa ntchito ndikusankha Import Data kuchokera ku menyu Ntchito . Dinani Zotsatira .
5. Sankhani Microsoft Excel monga gwero la deta (mwachitsanzo ichi).
6. Dinani pakani Powanizani , fufuzani foni ya adresi.xls pa kompyuta yanu, ndipo dinani Open .
7. Onetsetsani kuti Mzere Woyamba uli ndi mayina a mndandanda wa bokosi. Dinani Zotsatira .
8. Pa Sankhani Chiwongoladzanja Chowonekera, sankani Wogwirizana ndi SQL Server monga deta.
9. Sankhani dzina la seva yomwe mukufuna kuitumizira deta kuchokera ku bokosi la pansi la Server Name.
10. Tsimikizirani zowonjezera zowonjezera ndikusankha zosankha zomwe zikugwirizana ndi mawonekedwe anu a SQL Server.
11. Sankhani dzina lachinsinsi limene mukufuna kuti mulowetseko deta kuchokera mubokosi lotsegula. Dinani Zotsatira , kenako dinani Zotsatira kachiwiri kuti mulandire deta yanu kuchokera pa tebulo limodzi kapena angapo kapena mawonedwe pa Chithunzi Chapafupi Chakujambula kapena Pepala.

1. Mu bokosi lakutsikira pansi, pitani dzina la tebulo lomwe lilipo mumasamba anu kapena lembani dzina la tebulo latsopano lomwe mukufuna kulenga. Mu chitsanzo ichi, spreadsheet iyi ya Excel inagwiritsidwa ntchito popanga tebulo latsopano lotchedwa "osonkhana." Dinani Zotsatira .
2. Dinani batani Yomaliza kuti muyambe kutsogolo kusindikiza.
3. Pambuyo poyang'ana zochitika za SSIS zomwe zidzachitike, dinani Bokosi Lomalizira kuti mutsirizitse kuitanitsa.

Kutumizira Data kuchokera ku SQL Server 2012

SQL Server Import ndi Export Wizard ikukutsogolerani kudzera mu ndondomeko yotumizira deta kuchokera ku deta yanu SQL Server ku mtundu uliwonse. Chitsanzo ichi chimakuyendetsani njira yobweretsera mauthenga okhudzidwa omwe mwatumizidwa mu chitsanzo choyambirira ndikuwutumiza ku fayilo yapadela.

Nazi momwemo:

1. Tsegulani SQL Server Management Studio .
2. Perekani tsatanetsatane wa seva yomwe mukufuna kuigwiritsa ntchito ndi dzina loyenera ndi password ngati simukugwiritsa ntchito Windows Authentication.
3. Dinani Kulumikiza kuti mugwirizane ndi seva kuchokera ku SSMS.
4. Dinani pa dzina la deta yomwe mukufuna kugwiritsa ntchito ndikusankha Kutumizira Dongosolo kuchokera ku menyu. Dinani Zotsatira .
5. Sankhani Mtumiki Wachibadwidwe wa SQL Server monga deta yanu.
6. Sankhani dzina la seva yomwe mukufuna kutumizira deta kuchokera mu bokosi la pansi la Server Name .
7. Tsimikizirani zowonjezera zowonjezera ndikusankha zosankha zomwe zikugwirizana ndi mawonekedwe anu a SQL Server.
8. Sankhani dzina lachinsinsi chomwe mukufuna kutumizira deta kuchokera mu bokosi lakutsika lothandizira. Dinani Zotsatira .
9. Sankhani Malo Ophwanyidwa Pakupita Kuchokera ku bokosi lakutsikira pansi.
10. Perekani fayilo njira ndi dzina lomaliza mu ".txt" mu File Name mabokosi (mwachitsanzo, "C: \ Users \ mike \ Documents \ contacts.txt"). Dinani Pambuyo , kenako Yambanso kulandira Deta ya deta kuchokera ku matebulo amodzi kapena angapo .

1. Dinani Pambuyo kawiri, kenaka Tsirizani kuti muyambe kusindikizira.
2. Pambuyo poyang'ana zochitika za SSIS zomwe zidzachitike, dinani Bokosi Lomalizira kuti mutsirizitse kuitanitsa.