有没有工具可以将 SQL Server 2014 数据库转换为 2012?
I tried 生成脚本但是生成的包含数据的脚本太大,SQL Server Management Studio没有执行它,我需要同时拥有架构和数据。
To my knowledge, there are basically three two options for migrating a database to a lower version of SQL Server, without using 3rd party tools:
- 生成脚本(不太适合大量数据)
- 自定义脚本和 BCP 或导入/导出向导
SQL Server Integration Services (Transfer Database Task)
第一个选项如前所述,不适合您的情况。
第二个选项的方法是简单地编写数据库结构的脚本,然后使用导入/导出向导复制数据,一次一张表。请注意,如果数据库中有外键约束,您可能需要禁用这些约束,直到用数据填充所有表之后。这篇博文 http://www.mssqltips.com/sqlservertip/2810/how-to-migrate-a-sql-server-database-to-a-lower-version/详细解释了如何做到这一点。
Third option uses the SISS Transfer Database Task http://msdn.microsoft.com/en-us/library/ms141204.aspx which basically uses SMO to create the objects on the destination server and then transfers the data. This is the recommended way of migrating a database between SQL Server instances of different versions. SSIS requires that you have installed SQL Server Data Tools - Business Intelligence (SSDT-BI) for Visual Studio. Before SQL Server 2012, this was called Business Intelligence Development Studio (BIDS). You can download these here:
- Microsoft SQL Server 数据工具 - Visual Studio 2013 商业智能 http://www.microsoft.com/en-us/download/details.aspx?id=42313
- Microsoft SQL Server 数据工具 - Visual Studio 2012 商业智能 http://www.microsoft.com/en-us/download/details.aspx?id=36843
- 如果您没有 Visual Studio,SSDT-BI / BIDS 包含在 SQL Server 安装中 https://social.msdn.microsoft.com/forums/sqlserver/en-US/deb6aee1-8c16-4f5b-bffb-f2fc08bd12ae/business-intelligence-development-studio-2010-download.
本文内容由网友自发贡献,版权归原作者所有,本站不承担相应法律责任。如您发现有涉嫌抄袭侵权的内容,请联系:hwhale#tublm.com(使用前将#替换为@)