MS SQL 2000 to 2005 Migration

dman

dman

Perch
Hello,

I submitted a ticket to inquire about the option to migrate from MS SQL 200 to 2005 and wanted to check here on the forums as well.

I have a client who is using 2005 on the backend and it there are som compatibility issues between the two DBs. Specifically, I'm having issues replicating and recreating some tables, indexes and stored procedures between the 2000 and 2005 on SQL Management Studio v9.

I'm not a DB expert but I think there may be some way to get SQL SMS version 9 to output 2000 compatible scripts but it has not worked for me so far. To make this easier I looking into options to upgrade or migrate from MS SQL 2000 to 2005.

Can anyone provide guidance on the best course of action at Jodohost? Should I be looking to either migrate to 2005 or should I continue to try producing 2000 compatible scripts from SQL Server Management Studio v9?

Thanks for any help in advance!
 
You can make a new account where new DBs will go to a SQL 2005 server. This can be used for DB needs, we have done this on our shared side for those needing SQL 2005.

We are working on an upgrade plan for all 2000 servers as well, as we'd like to drop the legacy side, but had encountered a few issues in testing we are working to get past.
 
Hey Steven,

Thanks for the quick reply. That would be great and I have additional CP's available. So I just need to add a new Windows account in my reseller CP and it will default to use one of the MS SQL 2005 servers?

If Jodohost is working on the upgrading all 2000 versions to 2005 that would awesome and save me some work. I only need to do this with one DB right now but will probably need to do it with all of them sooner or later.

I also think I can handle my issue temporarily by using the Generate Scripts task in MS SQL SMS as follows:

1. Right clicking on the DB and choosing Tasks > Generate Scripts
2. Then click next and select the DB
3. In the options list set "Script for Server Version" to "SQL Server 2000"
4. Finish the task to generate the scripts and the scripts should work with MS SQL 2000
 
You must log in or register to reply here.
Back
Top