[MS-SQL] SQL 2008 백업 -> SQL 2005 복구 오류 해결

http://www.linglom.com/2009/08/11/restore-database-from-sql-server-2008-to-sql-server-2005-part-1-introduction/

위 링크에서 보면 결국 상위 버전에서 하위버전로 단순 백업(복제)및 복원(연결)은 불가능하다는 뜻 .

(영어 해석이 ㅠㅠ)

해결법은

1. 하위버전의 (2000 포함) DB의 Script 추출 마법사 (만약 많은 데이터를 포함하고자 하면 Script 파일 크기

   가 안드로메다.....ㅡ,.ㅡ;;)

   다음은 스크립트 추출단계:

reating Scripts to Move SQL Server 2008 Database to SQL Server 2005

These steps show you how to generate the necessary scripts.

• Use the scripting wizard in SQL Server 2008 to script data as well as schemas into SQL Server 2005 compatibility mode.
• Run "Generate SQL Server Scripts" wizard in SQL Server Management Studio (once Object Explorer is connected to the appropriate instance) by right clicking on database and selecting "Tasks –> Generate Scripts."
• Click "Script all objects in selected database" & then click "Next."
• Change script options: Specifically, set "Script for Server Version" to "SQL Server 2005" and set "Script Data" to "True". (SQL Server 2000 is also supported.) If you are putting the database on a new instance for the first time, make sure the "Script Database Create" option is set to "True." Click "Next" when you are happy with options.
• Finish the wizard.

After creating the file with these changes, you can run the script in SQL Server 2005 Management Studio to recreate the database in your development environment. You can now test data against SQL Server 2008 and SQL Server 2005.

2. EM 을 이용한 Export 및 Import 마법사를 이용한 방법