Downgrading SQL server 2008 to SQL Server 2005

sql-server-2005 sql-server-2008 database-backups downgrade
gersh picture gersh · May 11, 2009 · Viewed 24.8k times · Source

Are there any issues backing up a database from SQL Server 2008, and then importing it into SQL Server 2005? I had upgraded to SQL Server 2008, but 2008 seems to be too problematic so now I want to downgrade. Are there any problems in doing this?

Answer

BradC picture BradC · May 11, 2009

Well, you won't be able to restore a 2008 backup to a SQL 2005 server.

Easiest way to do it is to use the "Generate SQL Server Scripts" wizard to create a script (including schema and data) that you can run on SQL 2005 to create the database. See http://www.devx.com/dbzone/Article/40531

But back to the original issue: what problems are you having with SQL 2008?

Related questions

How to avoid the "divide by zero" error in SQL?

I have this error message: Msg 8134, Level 16, State 1, Line 1 Divide by zero error encountered. What is the best way to write SQL code so that I will never see this error message again? I could do either of the following: …

Read More
SQL Server query to find all permissions/access for all users in a database

I would like to write a query on a sql 2008 that will report all the users that have access to a specific database, or objects within the database such as tables, views, and stored procedures, either directly or due to …

Read More
sql query to return differences between two tables

I am trying to compare two tables, SQL Server, to verify some data. I want to return all the rows from both tables where data is either in one or the other. In essence, I want to show all the …

Read More