You can use the DTS Import and Export Wizard to automatically migrate data from Access database in SQL Server database. DTS can move data at a faster rate than the Microsoft Access Upsizing Wizard can, but DTS does not provide all of the features of the Access Upsizing Wizard. The following is a list of actions that the Access Upsizing Wizard can perform, but that the DTS Import and Export Wizard cannot perform:
- If an Access table has a primary key, the Access Upsizing Wizard automatically re-creates the primary key on the table that it generates on SQL Server; DTS does not.
- The Access Upsizing Wizard automatically migrates all rules and defaults that exist in a table to SQL Server; DTS does not.
- If tables in an Access database are related, the Upsizing Wizard automatically re-creates these relationships on SQL Server; DTS does not.
- DTS does not upsize any queries that exist in an Access database.