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.