Migrating a SQL Server 2008 database to SQL Server 2005

Published by: Sangeeta (1/29/2009 9:48:36 AM)

I have a database created in SQL Server 2008 Enterprise Edition. I want to migrate this database to another server which has SQL Server 2005. I have generated the SQL script of the database to be migrated though not sure of SQL Server 2008 being backward compatible.

Can anyone help me in this regard so that it would be easier for me to run only the script in the SQL Server 2005 server?

 

Most Popular Articles

• SQL Server 2008 Error: is not a valid login or you do not have permission
• Cannot start .aspx
• what is the difference between Text and String Data type in SQL Server
• Error: Microsoft OLE DB Provider for ODBC Drivers error '80004005'
• Why my MS SQL Server 2005 DSN Connection is not Working

Data Compression in SQL Server 2008 >>

<< Domain Controller Removed from SQL Server 2008 Database Server