Converting an Access Database to SQL ServerPosted: December 28, 2004
1.The easiest way to convert an Access database to SQL Server is to use the Upsizing Wizard. The Upsizing Wizard:
- Preserves database structure, including data, indexes, and default settings.
- Automatically converts Access validation rules and default settings to the appropriate SQL Server equivalents.
- Maintains table relationships and referential integrity after you upsize.
To run the Upsizing Wizard in Access 2000/2003, on the Tools menu, point to Database Utilities, and then click Upsizing Wizard.
2. Use SQL Server Data Transformation Services (DTS) to import the data from your Access database to a SQL Server database.