http://www.mytechmantra.com/LearnSQLServer/Downgrade_SQL_Server_Database_P1.html
http://social.msdn.microsoft.com/forums/en-US/sqldatabaseengine/thread/32a67469-0636-4ded-923f-2e257f7e68e1/
Options:
1.Create a blank data base in Sql 2005 and import data from sql 2008 to 2005 using import wizard.
2.Generate all script from sql 2008, and seperate primary key and foriegn key scripts from the generated script file.
3.Run that script in your Sql 2005 database.(To set PK and FK in 2005)
http://social.msdn.microsoft.com/forums/en-US/sqldatabaseengine/thread/32a67469-0636-4ded-923f-2e257f7e68e1/
Options:
1.Create a blank data base in Sql 2005 and import data from sql 2008 to 2005 using import wizard.
2.Generate all script from sql 2008, and seperate primary key and foriegn key scripts from the generated script file.
3.Run that script in your Sql 2005 database.(To set PK and FK in 2005)
No comments:
Post a Comment