I want to know if there is a way to convert an MSAccess DataBase to a SQL Server database without starting from the beginning.
我想知道是否有一种方法可以在不从头开始的情况下将MSAccess数据库转换为SQL Server数据库。
1 个解决方案
#1
5
There's a pretty verbose guide over at Microsoft that helps you get this process started. This is specifically for SQL Server 2008 though, using the SQL Server Migration Assistant (SSMA) which replaced the Upsizing Wizard: http://www.microsoft.com/sqlserver/2008/en/us/migration.aspx
微软有一个非常详细的指南，可以帮助您启动这个过程。这是针对SQL Server 2008的，使用SQL Server Migration Assistant (SSMA)替换了升级向导:http://www.microsoft.com/sqlserver/2008/en/us/migration.aspx
Download: SQL Server Migration Assistant 2008 for Access V4.0
Note: "SSMA for Access supports Access 97 - Access 2007 databases."
下载:SQL Server Migration Assistant 2008 for Access V4.0注:“SSMA for Access 97 - Access 2007数据库。”
#1
5
There's a pretty verbose guide over at Microsoft that helps you get this process started. This is specifically for SQL Server 2008 though, using the SQL Server Migration Assistant (SSMA) which replaced the Upsizing Wizard: http://www.microsoft.com/sqlserver/2008/en/us/migration.aspx
微软有一个非常详细的指南，可以帮助您启动这个过程。这是针对SQL Server 2008的，使用SQL Server Migration Assistant (SSMA)替换了升级向导:http://www.microsoft.com/sqlserver/2008/en/us/migration.aspx
Download: SQL Server Migration Assistant 2008 for Access V4.0
Note: "SSMA for Access supports Access 97 - Access 2007 databases."
下载:SQL Server Migration Assistant 2008 for Access V4.0注:“SSMA for Access 97 - Access 2007数据库。”