Create script in SQL Server 2008 which is compatible with SQL Server 2000

Question

I have a Database in SQL Server 2008 and i want to create the complete database script which is compatible with SQL Server 2000. All the datatypes that I've used are compatible with SQL Server 2000.

Easier to go the other way. Do the the script in 2000, it will almost certainly be OK in 2008. More a question of not making use of new features, than old fetaures no longer there. — Tony Hopkinson
– Tony Hopkinson, Commented Dec 28, 2011 at 14:05

user596075 · Accepted Answer · 2011-12-28 14:03:25Z

8

Here's what you'd do for SQL Server 2000 compatability:

Right-click on your database, Tasks -> Generate Scripts...
Choose your entire database
In Set Scripting Options click the Advanced button
There is an option for Script for Server Version
Select the drop down option for SQL Server 2000

answered Dec 28, 2011 at 14:03

user596075

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Create script in SQL Server 2008 which is compatible with SQL Server 2000

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related