suppose i have database tht is created in sql 2008...but i hav to open tht database in sql 2005..how can i do it
sql 2008 to 2005
how to open sql 2008 database to sql2005 database
Loading
Know the answer? Post it — somebody with the same question will find it here.
Sign in to answer this question
It is the same account you read, post and publish with — and you will come straight back to this page.
Jignesh TrivediPosted Jan 21, 2013, 10:53 PM
before downgrade to sql 2005, check your any database objects (SP, function, table etc) are not using any feature of SQL server 2008.
please refer below link it might help you to resolve issue.
http://chamilaw.blogspot.com/2011/04/how-to-restore-sql-server-2008-to-sql.html
http://sqlblog.com/blogs/jonathan_kehayias/archive/2010/01/11/downgrading-from-sql-2008-to-2005.aspx
hope this will help you.