Migration Problem of Sql 2000 to SQL 2005

Hi all,

We migrated our database from SQL 2000 to SQL 2005. But we faced some problems, according to the requirements of our project we dont want to apply some constraints on some fields of some tables. But when we run the database script of our old database on SQL 2005, it applied many constraints which causing some serious problems in our project. There are about 100+ tables in our database and some one told me that we have to false every constraint manually. Now, my question is that is there any solution of our this problem.

Best Regards

hi,

can you please expand on

it applied many constraints which

can you post some SQL2000 DDL and how you like it to be in SQL2005?

regards

|||

We need some additional information here to help, could you expand on exactly what constraints you are seeing? One thing you may want to consider is that you can just move your SQL 2000 database file (data and log) to the SQL 2005 computer and attach the file, that should result in the exact same structure.

Mike