Guide to Migrating from Microsoft Access to SQL Server 2005
|
This white paper covers migrating Microsoft Access databases to SQL Server 2005 and discusses the differences between the two platforms. SQL Server Migration Assistant for Access (SSMA Access) is the best tool for this type of migration; this paper tells you how to use it to mitigate potential problems in database conversion. For additional information, also see the white paper Microsoft Access or SQL Server 2005: What's Right in Your Organization?
Included in this document:
| • | Introduction |
| • | Overview of Access-to-SQL Server 2005 Migration |
| • | Migration Wizard |
| • | Migrating Database Objects |
| • | Table Migration Potential Problems |
| • | Jet Syntax Potential Problems |
| • | Functions |
| • | Data Migration |
| • | Conclusion |
