Migrating an Access database to a SQL Server database two methods (illustrated) _mssql

ACCESS2000 file

Open with ACCESS2007 and migrate into SQLSERVER2005.

Open the ACCESS2007 database tool

method One : Using ACCESS2007 's own database migration Tool

1, open the ACCESS2007 Database Migration Wizard

2, click the SQL Server button, Pop-up Upsizing Wizard dialog box

3. Select New Database

4, enter the computer name, my local computer name is Joe, because SQL Server is installed locally, so choose to use a trusted connection

The database name defaults to it

5, select all the tables, move to the right border

6, the table index also promoted to SQL Server

7, because there is no application, this step can be skipped directly

8. Click the Finish button to start migrating the database to SQL Server

9. Start migration

10, refresh the SQLSERVER2005 in the Object Explorer database

After migrating to SQL Server, SQL Server automatically adds the three letters to the name of the Access database after it

11. Open a data table in Lygsql to see if the migration is successful

12, table constraints also complete migration success

method Two : Use the SQLSERVER2005 Data Import Export Wizard

Limitations: SQLSERVER2005 The Data Import Export Wizard tool supports only ACCESS2003 or the following files

1. Create a new database in SQL Server with the same name as an Access database Lygl

2, select the LYGL database, and then press the right key-"task-" Import data

3. Open the SQL Server Import Export Wizard

4. Next step

Tip: If the Access database has a password, clicking Next will make an error, so please remove the password from the Access database before clicking Next.

5. Click Next

6, then click Next

7, then click Next

Check the first box, and SQL Server will automatically pick up all the tables in the Access database

8. Click Next

9, the last click to complete the button

10. Refresh the database in SQL Server Object Explorer

11, open the table

The data is in the import.

But table constraints are not imported, and this is a little less than the Database Migration Wizard that access comes with

This is the process of migration.