NOTE: If you are using Access 97 and higher versions, you can also use the SQL Server Migration Assistant for Access. For more information about the SQL Server Migration Assistant for Access, visit the following Microsoft Web site:
http://www.microsoft.com/sqlserver/en/us/product-info/migration-tool.aspx#Access
(http://www.microsoft.com/sqlserver/en/us/product-info/migration-tool.aspx#Access)
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.
http://answers.microsoft.com/en-us/office/forum/office_2007-access/export-access-table-schema-to-sql/8a6d1052-86b0-4080-9147-6c2c64ba1d9c
No comments:
Post a Comment