SQL05 to SQL02 database conversion?

G Day! I have a database in a dev environment that is in SQL05 I wish to deploy this to a remote production server SQL02. The wizards in SQL05 copy from older versions to 05 but not in reverse. Any suggestion of how to reliably to this conversion.

Kindest regards

Mark

[288 byte] By [DrOZ] at [2007-12-25]
# 1

Are you trying to deply to a SQL 2000 machine? We haven't released a SQL 2002 version. :) You have several options for restoring a newer version to an older version. Please see this thread for more info:

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=71519&SiteID=1

Thanks,
Sam Lester(MSFT)

SamuelLester-MSFT at 2007-9-3 > top of Msdn Tech,SQL Server,SQL Server Tools General...

SQL Server

Site Classified