How to Convert MS Access Database to SQL Server Database

Hello guys at this time i will show to you on how to convert your MS Access Database to
SQL Server Database, to do this, just follow those few steps below.

on your MS Access database, go to Database Tools, go to Move Data tab, then click
SQL Server

then the Up-sizing wizard will prompt, allowing you to use an option, at this time since
i am not using Existing Database, so i select Create new Database, then Click Next
button,

since i am converting to SQL Server, if you do this, you must enter your current SQL
Server name, since i am using Developer Edition of SQL Server, the server name
is only my computer name, not like if i am using Express, my server name will look like
this MRHUMBLE\Express, that is the one differences of Express and Dev. Edition
and  for more knowledge about their differences i will tackled those later,but now let focus
on this tutorial, then Enter Database name, but now i am using the Default

then it will look like this, select the table you want up-size, then click the Left Arrow button
for you to Export on SQL Server, then follow the next step below,

this is the default up-sizing

then here you go,,,,

after hitting the OK button, you will came out with up-sizing Report

as you can see at the image above, the default Database Name, create by the Wizard
is on my SQL Server, and together with the Table.

Note: the Sql Server Database that i am using is SQL Server 2005 Dev. Edition and 
MS Access 2007

The Hardest Thing to Do is to Do Nothing ^_^

These icons link to social bookmarking sites where readers can share and discover new web pages.

• 
• 
• 
• 
• 
• 
• 
• 
• 
• 
• 

Tags: Database, MS Access, SQL Server