I would like to migrate a local Access database to SQL server. I have opened an Azure account with an SQL server at an https://manage.windowsazure.com adress. Can someone explain me how to do that ?

Scenario: I have downloaded a sample database zipcodes from about.com database site. I am using this database as my data source.

There are three tables in that source database. But, I am transferring a table States with data to SQL Server 2012 database.

Step 1: Create a package and Add ADO NET connection in connection manager

Creating a new connection

Configure connection with MS Access database

Click OK

Step 3: Add ADO NET source into Data Flow Task

Configure ADO NET source task with database connection and table

Step 4: Add ADO NET destination and connect to your local database.

Create connection for Destination database

Create new table. This table schema is extracted from the data source

Map columns between data source and destination  in the Mappings page and Click OK

We have completed the package design.

Step 5: Execute the package now

We have created a simple package to migrate MS Access table to SQL Server.

You can also download Microsoft Access Database Engine 2010 Redistributable here.

Hi PedroFrancisco,

According to your description, you want to migrate Access database to Azure SQL database. You can use the SQL Server Migration Assistant (SSMA) for Access tool to perform the whole process.

For detailed steps  about how to use SSMA for Access to migrate Access database to Azure SQL database, please review the following articles.

Migrating Access Databases to SQL Server/Azure SQL DB (AccessToSQL)
https://msdn.microsoft.com/en-us/library/hh313051%28v=sql.110%29.aspx?f=255&MSPPError=-2147217396

Access to SQL Server Migration: How to Use SSMA
http://blogs.msdn.com/b/ssma/archive/2011/01/28/access-to-sql-server-migration-how-to-use-ssma.aspx


Thanks,
Lydia Zhang

VIMD, could you please stop to post the intellectual Content of other here as yours? https://sqlserverrider.wordpress.com/2013/01/21/upload-data-from-ms-access-database-to-sql-server-ssis/