[SQL Server] data migration between access and SQL Server

 

First, we will introduce how to migrate access data to SQL Server. Here we use the access northwind database as an example.

This is the table structure.

 

OK. First, open SSMs, select any database, right-click the database, and choose task> Import database.

 

Welcome to the next step in the Wizard, select the data source

If the format is. accdb, you can select Microsoft Office 12.0 access ...... That, and the following user name and password can not be left blank.

Next, select the target Data source:

The target and server names remain unchanged. Select the database or click Create.

Then, complete the next step.

 

The Export and Import principles are similar.

In fact, the conversion between SQL server data lies in the ing of data types. For c: \ Program Files \ Microsoft SQL Server \ 100 \ DTS \ mappingfiles, we can see the XML file of the ing definition.