how can I transform database from sql server 2005 to 2000
如何将数据库从sql server 2005转换为2000
2 个解决方案
#1
First make sure that you aren't using any native 2005 features like included columns on indexes, XML features, etc. Then you can script the schema out using SSMS, and export the data using BCP or SSIS to SQL 2000. Some vendor tools exist like RedGate SQL Compare and Data Compare that make doing this a whole lot easier if you have primary keys defined on your tables.
首先确保您没有使用任何本机2005功能,例如索引,XML功能等上包含的列。然后,您可以使用SSMS编写模式脚本,并使用BCP或SSIS将数据导出到SQL 2000.存在一些供应商工具比如RedGate SQL Compare和Data Compare,如果你在表上定义了主键,那么这样做会更容易。
#2
Use SSIS to export the database directly to SQL Server 2000.
使用SSIS将数据库直接导出到SQL Server 2000。
#1
First make sure that you aren't using any native 2005 features like included columns on indexes, XML features, etc. Then you can script the schema out using SSMS, and export the data using BCP or SSIS to SQL 2000. Some vendor tools exist like RedGate SQL Compare and Data Compare that make doing this a whole lot easier if you have primary keys defined on your tables.
首先确保您没有使用任何本机2005功能,例如索引,XML功能等上包含的列。然后,您可以使用SSMS编写模式脚本,并使用BCP或SSIS将数据导出到SQL 2000.存在一些供应商工具比如RedGate SQL Compare和Data Compare,如果你在表上定义了主键,那么这样做会更容易。
#2
Use SSIS to export the database directly to SQL Server 2000.
使用SSIS将数据库直接导出到SQL Server 2000。