How to Convert an Access Database to SQL Server

In this tutorial, we will learn how to convert an access database to SQL Server database.

Don't forget to check out our site http://howtech.tv/ for more free how-to videos!
http://youtube.com/ithowtovids - our feed
http://www.facebook.com/howtechtv - join us on facebook
https://plus.google.com/1034403827176... - our group in Google+

In this easy step by step tutorial, we will teach you how to convert Access database to SQL Server. SQL Server is a versatile database system being used world widely. Customers switching from their current database system to SQL Server face the issue of migrating data from existing system to the new database. Hence SQL Server facilitates this requirement to import data from several different sources.

Step#1: SQL Server Migration Tool

SQL Server provides a migration tool called SQL SERVER MIGRATION ASSISTANT to facilitate the customers to import data from different sources. You can download it from Microsoft's official website. Simply click on the download button and specify the location where you wish to save it. Next, extract and open up the setup file to begin the installation.

Just follow the step by step procedure to install and the application. In case if it prompts you for the license key, you can easily download it for free by registering yourself to Microsoft.

Step#2: Initializing Migration Process

Once you open up the migration tool, a wizard will open up. Just hit next on the welcome screen and create a new project. Here you can name your project, specify the location and then choose the version of SQL SERVER you want to migrate the database to. In our case, we will convert Access to SQL Server 2008.

Step#3: Adding Access Database

To convert Access to SQL, we need to add the database here. Click the ADD DATABSE button and locate your database file. Press NEXT to continue.

Step#4: Defining SQL Server

Next, select the objects to migrate. For this tutorial, let's leave this to default and hit NEXT, since we will be migrating the whole database.

In the next window, we will have to create a connection with the SQL SERVER. Provide the Server's name, which in this case will be local since it is installed on the same machine, and specify the database name. If you want to create a new database, just type its name over here and the wizard will automatically create it. Click on NEXT to continue.

Step#5: Migrating Access Database

The conversion process will begin, and it would take a few seconds for the processing to complete.

Step#6: Verification of Data Migration

Once completed, close the migration wizard and open up the SQL server. You will notice a new database has appeared over here. Expand the folder, right click on any of its table and choose the "select top 1000 rows" option to verify the contents of the database.

Finally, we have successfully shown in this tutorial how to convert an access database to SQL Server database.

---

Closed Caption:

in this video we will show you how to
convert an access database to an SQL
servers database for this will be using
migration tools called SQL Server
migration assistant you can download it
from microsoft official website simply
click on the download button and specify
the location where you wish to save it
next
just extract and open up the setup file
to begin the installation
just follow the step-by-step procedure
to install the application in the case
of it prompts you for the license key
you can easily downloaded for free by
registering yourself to Microsoft once
you open up the migration tool a wizard
will open just hit next on the welcome
screen and now you can create a new
project here you can name your project
specify the location and then choose the
version of SQL Server you want to
migrate the database to in our case we
will be migrating to SQL Server 2008
with that done you have to add the
database which has to be converted click
the add database button and locate your
database file just hit next after that
to continue with the process in the next
step you can select the objects to
migrate for this tutorial let's leave
this to default and hit next
since we will be migrating the whole
database in the next window we will have
to create a connection with the SQL
Server provide the server's name which
in this case will be local since it is
installed on the same machine and
specify the database name if you want to
create a new database just type its name
over here and the wizard will
automatically create it with that done
simply click on next
the conversion process will begin after
that and it will take a few seconds for
the process to complete
once done simply close the migration
wizard and open up the SQL server now
you will notice a new database has
appeared over here let's expand the
folder right-click on any of its tables
and choose the select top 1000 rows
option to view the contents of the
database and you can see over here that
the access database has been
successfully converted into an SQL
servers database