All geek questions in one place

How to export a database from SQL Server 2008 to SQL Server 2005

I have a database that I created using SQL Server 2008. I have to attach this database to SQL Server 2005. When I try to do this, I got an error because the database was made in a higher version (2008) . How can i do this? Any help?

+3
source share
3 answers

You cannot attach a SQL Server 2008 database to an instance of SQL Server 2005. Even when using the SQL Server 2005 compatibility level.

SQL Server 2005 SQL Server , .. SQL Server 2008 .

+2

2005 , Schema Diff 2008 2005 2005 . Data Diff ( ) . , , - 2008 , 2005 .

+1

You can also use RedGate SQL Compare and SQL Data Compare to facilitate migration. This is a commercial tool. You can download a demo copy from your website.

+1
source

Source: https://habr.com/ru/post/1741111/

More articles:


All Articles