Two Methods for migrating an ACCESS database to an SQL Server database (graphic description)

ACCESS2000 File

Open it with ACCESS2007 and migrate it to SQLSERVER2005

Open ACCESS2007 database tool

Method 1: Use the database migration tool that comes with ACCESS2007

1. Open the database migration wizard for ACCESS2007

2. Click SQLSERVER to bring up the promotion wizard dialog box.

3. Select create database

4. Enter the computer name. My local computer name is joe. Because SQLSERVER is installed locally, you can use a trusted connection.

The default database name is enough.

5. Select All Tables and move them to the right border.

 

6. Promote table indexes to SQLSERVER.

7. Because there is no application, skip this step.

8. Click "finish" to start database migration to SQLSERVER.

9. Start migration

10. Refresh the database in the object Resource Manager in SQLSERVER2005.

After the database is migrated to SQLSERVER, SQLSERVER automatically adds the SQL letters after the name of the ACCESS database.

11. Open a data table in LygSQL to check whether the migration is successful.

12. Table constraints are also completely migrated

Method 2: Use the data import and export wizard that comes with SQLSERVER2005

Restrictions: The data import/export wizard tool provided by SQLSERVER2005 only supports ACCESS2003 or the following files

1. Create a database Lygl with the same name as the ACCESS Database in SQLSERVER.

2. Select the Lygl database, right-click the database, and choose task> import data.

3. Open the SQLSERVER Import and Export wizard

 

4. Next Step

Tip: If the ACCESS database has a password, an error occurs when you click Next. Therefore, remove the ACCESS Database Password Before you click Next!

5. click Next.

6. click Next.

7. click Next.

Check the first box. SQLSERVER will automatically check all the tables in the ACCESS database.

8. click Next.

9. Click Finish.

10. Refresh the database in the SQLSERVER object Resource Manager.

11. Open a table

All data is imported.

However, the table constraints are not imported, which is a little worse than the database migration Wizard provided by ACCESS.

 

 

This is the migration process.