Dhowaan, waxaan ku qasbanaatay inaan xogta ka haajiro kaydka Helitaanka una guuro ^(Access)SQL Server 2014  sababtoo ah xog-ururintaygu aad ayuu u waynaaday si aan^(Access) wax looga qabto. In kasta oo hab-socodku uu yahay mid fudud, haddana waxaan qiyaasay in aan qori doono maqaal leh tilmaamo tallaabo-tallaabo ah.

Marka hore, waxaad u baahan tahay inaad hubiso in lagu rakibay SQL Server ama SQL Server Express kombayutarkaaga. Markaad soo dejisanayso SQL Server Express kombayutarka^{(SQL Server Express)} gaarka ah, hubi inaad la soo degto nooca Adeegyada Sare^{(Advanced Services)} . Haddii aadan samayn, markaa matoorka xogta lama rakibi doono oo waxaad yeelan doontaa SQL Management Studio iyada oo aan la helin tusaale xog ururin ah oo lagu xidho.

Marka aad si sax ah u rakibto Server-ka SQL^{(SQL Server)} , waxaad sii wadan kartaa tillaabooyinka hoose si aad u soo geliso kaydka Access database-ka cusub ee SQL Server .

Ku wareeji Xogta Helitaanka^{(Transfer Access Database)} SQL Server^{(SQL Server)}

Fur Studio Management Server SQL^{(SQL Server Management Studio)} oo ku xidh server-ka xogta ee aad rabto inaad ku soo dejiso xogtaada Access . Under Databases , midig-guji oo dooro Database cusub^{(New Database)} . Haddii aad hore u haysatey xog-ururin oo aad si fudud u rabto inaad ka soo dejiso laba jaantus oo ka mid ah Access , ka dib uun kan ka bood oo u gudub xogta soo dejinta^{(Import Data)} ee hoose. Kaliya^(Just) midig-guji xogtaada hadda jirta halkii aad mid cusub ka abuuri lahayd.

Haddii aad abuurayso xog-ururin cusub, horay u sii oo u bixi magac oo habee dejinta haddii aad rabto inaad ka beddesho khaladaadka.

Hadda waxaan u baahanahay inaan xaq u gujino xogta tijaabada^(Test) ee aan hadda abuurnay oo aan doorano Hawlaha^(Tasks) ka dibna soo dejinta Xogta^{( Import Data)} .

On the  Select a Data Source^{( Choose a Data Source)} sanduuqa wada hadalka, dooro  Microsoft Access (Microsoft Jet Database Engine)  sanduuqa hoos u dhaca.

Marka ku xigta File name^{(File nam)} e, guji Browse oo u gudub kaydka xogta Access ee aad rabto inaad soo dejiso oo guji Open . Ogow in kaydku aanu ku jiri karin Access 2007 ama qaab ka sareeya ( ACCDB ) maadaama SQL Server aanu aqoonsanayn! Markaa haddii aad haysato kaydka Access 2007 ilaa 2016 , marka hore u beddel qaabka 2002-2003 Database  format ( MDB ) adiga oo aadaya  File – Save As .

Horey u soco oo guji Next si aad u doorato meesha aad ku socoto. Mar haddii aad midig-gujisay kaydka xogta ee aad rabtay inaad xogta geliso, waa in mar horeba lagu dhex doortaa liiska. Haddaysan ahayn, ka dooro Macmiilka Dhaladka ee SQL^{(SQL Native Client)} meesha Destination - ka hoos u dhaco. Waa inaad ku aragtaa tusaale ahaan kaydka xogta ee hoos yimaada Magaca Serverka^{(Server Name)} kadibna aad awood u yeelan karto inaad doorato xogta gaarka ah ee hoose markaad doorato habka aqoonsigaaga.

Guji Next ka bacdina sheeg sida aad u rabto in aad xogta uga gudbiso Access to SQL adiga oo dooranaya mid ka koobi xogta hal ama in ka badan^{(Copy the data from one or more tables)} ama Qor su'aal si aad u qeexdo xogta lagu wareejinayo^{(Write a query to specify the data to transfer)} .

Haddii aad rabto in aad nuqul ka sameysid dhammaan miisaska ama qaar ka mid ah jaantusyada laga soo bilaabo database Access iyada oo aan wax xog ah lagu samayn, dooro ikhtiyaarka ugu horreeya. Haddii aad u baahan tahay inaad ka koobiyayso oo keliya safafka iyo tiirarka xogta shaxda, ka dib dooro doorashada labaad oo qor su'aal SQL ah .

Sida caadiga ah, miisaska oo dhan waa in la doortaa oo haddii aad riixdo badhanka Edit  Mappings , waxaad u habayn kartaa sida beeruhu u khariidadeeyaan labada miis. Haddii aad u samaysay xog-ururin cusub soo dejinta, markaas waxay noqon doontaa nuqul sax ah.

Halkan waxa aan ku haystaa hal miis oo keliya xogtayda Access . Guji Next^{(Click Next)} oo waxaad arki doontaa shaashadda Run Package halkaasoo ^{( Run Package)}Run Isla markiiba^{( Run Immediately)} la hubiyo.

Guji Next ka dibna dhagsii dhame^(Finish) . Waxaad markaas arki doontaa horumarka xogta wareejinta sida ay u dhacdo. Ka dib marka la dhammeeyo, waxaad arki doontaa tirada safafka lagu wareejiyay miis kasta ee tiirka Fariinta .^(Message)

Guji Xir^(Close)  oo waad dhammaatay. Hadda waad sii socon kartaa oo aad ku ordi kartaa SELECT miisaskaga si aad u hubiso in dhammaan xogta la keenay. Hadda waxaad ku raaxaysan kartaa awoodda SQL Server si aad u maamusho xogtaada.

Dhibaato ma jiraan ka soo dejinta xogtaada Helitaanka^(Access) SQL Server ? Hadday sidaas tahay, faallo ku dheji oo waxaan isku dayi doonaa inaan caawiyo. Ku raaxayso!

Migrate Data from MS Access to SQL Server Database

Recently, I had to migrate thе data from an Access database to SQL Server 2014 becaυse my database waѕ getting too large for Access to handle. Εven thоugh the process is fairly simple, I figured I would write an article with step-by-step instructions.

First, you need to make sure you have SQL Server or SQL Server Express installed on your computer. When downloading SQL Server Express on a personal computer, make sure you download the version with Advanced Services. If you don’t, then the database engine won’t be installed and you’ll have SQL Management Studio without any database instance to connect to.

Once you have SQL Server installed properly, you can continue with the steps below to import the Access database into a new database in SQL Server.

Transfer Access Database to SQL Server

Open SQL Server Management Studio and connect to the database server you want to import your Access database into. Under Databases, right-click and choose New Database. If you already have a database and you simply want to import a couple of tables from Access, then just skip this and go to the Import Data step below. Just right-click on your current database instead of creating a new one.

If you’re creating a new database, go ahead and give it a name and configure the settings if you want to change them from the defaults.

Now we need to right-click on the Test database we just created and choose Tasks and then Import Data.

On the Choose a Data Source dialog box, select Microsoft Access (Microsoft Jet Database Engine) from the drop down box.

Next to File name, click on Browse and navigate to the Access database you want to import and click Open. Note that the database cannot be in Access 2007 or higher format (ACCDB) as SQL Server does not recognize it! So if you have a 2007 to 2016 Access database, first convert it to the 2002-2003 Database format (MDB) by going to File – Save As.

Go ahead and click Next to choose the destination. Since you right-clicked on the database you wanted to import the data into, it should already be picked in the list. If not, select SQL Native Client from the Destination drop down. You should see the database instance under Server Name and then be able to choose the specific database at the bottom once you pick your method of authentication.

Click Next and then specify how you want to transfer the data from Access to SQL by choosing either Copy the data from one or more tables or Write a query to specify the data to transfer.

If you want to copy all the tables or just some of the tables from the Access database without any data manipulation, choose the first option. If you need to copy only certain rows and columns of data from a table, then choose the second option and write a SQL query.

By default, all the tables should be selected and if you click the Edit Mappings button, you can configure how the fields map between the two tables. If you created a new database for the import, then it’ll be an exact copy.

Here I have only one table in my Access database. Click Next and you’ll see the Run Package screen where Run Immediately should be checked.

Click Next and then click Finish. You’ll then see the progress of the data transfer as it occurs. After it is completed, you’ll see the number of rows transferred for each table in the Message column.

Click Close and you’re done. You can now go ahead and run a SELECT on your tables to make sure all the data got imported. Now you can enjoy the power of SQL Server for managing your database.

Any problems importing your data from Access to SQL Server? If so, post a comment and I’ll try to help. Enjoy!

Related posts

• Jadwalka xogtaada Excel

• Sida loo shaandheeyo xogta gudaha Excel

• Adeegso Excel Mobile's cusub ee shaqada "Ka Geli Xogta Sawirka".

• Isticmaal Hawlaha Kooban si aad u soo koobto Xogta ku jirta Excel

• U isticmaal Excel Qalab ahaan si aad xogta uga koobbiso Shabakadda

• Ka raadi Iimaylka Muuqaalka ee soo-diraha, taariikhda, ereyga muhiimka ah, cabbirka iyo in ka badan

• Sida loogu daro madaxyada iyo cagaha gudaha PowerPoint

• Sida Loo Raad-raaco Isbeddellada Ku Yimaadda Word (Online, Mobile, iyo Desktop)

• Si Toos ah ugu Guuri E-maillada faylalka ku jira Muuqaalka Adeegga Xeerarka

• Sida loo xafido erayga sirta ah ee Excel File

• Muuqaalka Microsoft kama jawaabayo? 8 hagaajin la isku dayo

• Sida Sheekada Maqalka Loogu Daro Soo Bandhigida Powerpoint

• Sida loo abuuro Gantt Charts gudaha Microsoft Excel

• Hagaha ugu dambeeya ee Dayactirka Faylka Erayga Burburay ama La Musuqmaasuqay

• Isticmaal daaqada daawashada Excel si aad ula socoto unugyada muhiimka ah ee buug-shaqeedka

• Sida loogu daro ama looga saaro faallooyinka Word

• Sida Loo Sameeyo Jadwalka socodka gudaha Word iyo Excel

• Sida loo furo MDI Files

• 12 Talooyin iyo tabaha Microsoft Word oo faa'iido leh

• Sida loogu Gudbiyo Imaylada Muuqaalka Gmail