convert sql server 2008 database to sql server 2005

Hi I have don开发者_开发问答e this before but cannot find out how i did it. I have a website that has a sql server 2008 db which needs to be put on a sql server 2005. i remember scripting it down to recreated it in 2005 i thought i did it through the 'generate script' wizard but this didnt script down the data, just the tables and stored procedures. what would be the best way of doing this?

---

you are actually doing it right, you just have to select the proper options.

• Right click on DB.
• Select Tasks
• Select Generate Scripts
• Choose your objects
• Under scripting options, click on Advanced

Under Script for Server Version, choose SQL Server 2005

Under Types of data to script, choose Schema and Data

---

use the following convert options while doing the data export:

• Script for Server Version = 'SQL Server 2005'
• Script Data' = 'True'
• Script Database Create' = 'True'

edit: check out http://www.sqlservermart.com/HowTo/MSSQL_Convert_2008_To_2005.aspx for more info :-)

---

Try DBSourceTools.
http://dbsourcetools.codeplex.com.
It is specifically designed to script databases to disk, including all objects and data, and then re-create them through a deployment target.
I have done this many times before from 2008 to 2005, and the tool takes care of all database dependencies and data.