Problems when migrating from SQL Server 2000 to SQL Server 2008
I have a primary key and identity issues when migrating databases and tables from SQL Server 2000 to SQL Server 2008.
In SQL Server 2000, some tables have primary key ID and I set Identity yes. When I export to SQL Server 2008 a few tables already do not have a PRIMARY KEY and Identity No.
I've tried the Edit Mapping in Export with check list export identity, but the result is the same, NO PRIMARY KEY and Identity NO
How to solve this problem?
I think you did not create table on SQL Server 2008 server.
Create the table schema script on SQL Server 2000 and create the same table in SQL Server 2008.
Load the table with Keep Identity option in Import/Export wizard.
Hope it helps. Thanks.
链接地址: http://www.djcxy.com/p/17138.html上一篇: 使用主键行数获取所有表名