0

I have created a database in SQL Server 2008, My database have more then 100 tables, but when i am trying to restore the database in SQL Server 2005, then its not allowing me to restore.

Does any one have idea how to do that, I tried the same using generate script but it doesnot work for me.

Thanks in advance.

Kamal Kant Pansari

Improve this question
1
  • If you're using backup/restore, you can't do it backwards. The work around is scripting. If you're trying scripting and getting errors please let us know what specific problems you're getting. Commented Apr 25, 2011 at 14:35

2 Answers 2

Reset to default
3
  • Use the scripting wizard in SQL Server 2008 to script data as well as schemas into SQL Server 2005 compatibility mode.
  • Run "Generate SQL Server Scripts" wizard in SQL Server Management Studio (once Object Explorer is connected to the appropriate instance) by right clicking on database and selecting "Tasks –> Generate Scripts."
  • Click "Script all objects in selected database" & then click "Next."
  • Change script options: Specifically, set "Script for Server Version" to "SQL Server 2005" and set "Script Data" to "True". (SQL Server 2000 is also supported.) If you are putting the database on a new instance for the first time, make sure the "Script Database Create" option is set to "True." Click "Next" when you are happy with options.
  • Finish the wizard.
Improve this answer
Sign up to request clarification or add additional context in comments.

Comments

-1

The conversation in this thread may be of interest: http://www.sqlservercentral.com/Forums/Topic584539-357-1.aspx

Improve this answer

Comments

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.