Red Gate forums :: View topic - Create a DB from 2005 on 2000?
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Packager Previous Versions
SQL Packager Previous Versions forum

Create a DB from 2005 on 2000?

Search in SQL Packager Previous Versions forum
Post new topic   Reply to topic
Jump to:  
Author Message
sdoran



Joined: 25 Jan 2007
Posts: 9

PostPosted: Tue Mar 04, 2008 4:12 pm    Post subject: Create a DB from 2005 on 2000? Reply with quote

Is there a way to make Red Gate generate the right scripts to build a db on sql 2000 from a sql 2005 db? I keep getting errors in the package when I set up the package with the default options.
Back to top
View user's profile Send private message
Michelle Taylor



Joined: 30 Oct 2006
Posts: 529
Location: Red Gate Software

PostPosted: Tue Mar 04, 2008 4:26 pm    Post subject: Reply with quote

SQL Packager should try to create a package which can be built on SQL Server 2000 if you target a SQL Server 2000 database (with 'upgrade a previous database') when building the package. However, it can't generate the correct script in the following cases:

1) You have stored procedures / views / functions with syntax which will not work on 2000

2) You have any 2005-only features in your database (the new object types, data types etc)

There are also a variety of other minor issues which might stop a 'downgrade' package working properly (e.g. there are some issues around full text catalogues, and around owners of objects).
Back to top
View user's profile Send private message
sdoran



Joined: 25 Jan 2007
Posts: 9

PostPosted: Tue Mar 04, 2008 4:28 pm    Post subject: Reply with quote

I am seeing the issues around the login and user creation scripts. Suggestions on how to fix?
Back to top
View user's profile Send private message
Michelle Taylor



Joined: 30 Oct 2006
Posts: 529
Location: Red Gate Software

PostPosted: Wed Mar 05, 2008 12:31 pm    Post subject: Reply with quote

If you're getting 2005 syntax for logins and users, that probably means Packager isn't picking up that it's meant to be targetting 2000 properly.

I just loaded up Packager and packaged a 2005 database full of various users, which appeared to be generating 2000 syntax correctly when given an empty database on a SQL Server 2000 server on the right-hand side of the initial database chooser dialog.

Could you tell me exactly how you are creating the pacakge and give more details on the problems you are encountering?
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group