All geek questions in one place

Creating a SQL Server 2000 Database Using SQL Server 2008

My development machine has a version for SQL Server 2008 developers. The production server on which I am going to do some development has SQL Server 2000 on it. Is there a way to create a 2000 database using my 2008 version for developers? Or do I need to create it on server 2000 and transfer it to my development machine?

+3
source share
5 answers

Unable to move development database to production. After updating the database file to SQL 2008 format, it is not possible to switch to SQL 2000 format.

T-SQL . . , , , . - SQL 2008, SQL 2000.

db 80 2008 2000, , 2008 . , , , SQL 2000.

+4

80 , sql. db 2008 2000.

+3

:

SQL 2008, , "", " ". , (, script Drop, script Data...), .

SQL script .

+1

, 2000; 2008 , 2000, 80, ; 2000, - .

If you need to make a full backup and restore the new database, you will be better off with an instance of 2000 to connect to development, MSDE can be installed as a named instance along with the 2008 release.

0
source

yes, the database can be restored with SQL 2008 even with compatibility 80 on the SQl 2000 instance. If you need to restore, script the DB and objects and recreate them on SQl 2000. -Ashok

0
source

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

More articles:


All Articles