SQL Server - How to migrate the sqlserver2008 to sqlserver2005?

Asked By mohan kumar on 21-Sep-12 11:08 PM
I want to migrate sqlserver2008 database contain (tables,SP,Views,Functions,etc) to sqlserver2005. please give solution for this
Robbe Morris replied to mohan kumar on 22-Sep-12 06:11 PM
Hmm, I think you are going to have to do this manually via generating the scripts to both create the schema as well as move the data.  SQL Server 2005 cannot work with the 2008 format and features.
Jitendra Faye replied to mohan kumar on 24-Sep-12 12:50 AM
refer this link-

http://www.sqlservermart.com/HowTo/MSSQL_Convert_2008_To_2005.aspx

Here you will get pictorial help.