Converting an Access Database to SQL Server

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.




Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s