December 6, 2004 at 12:54 am
How could I transfer my database from my old machine sql 7.0 to a new machine sql 2000. This includes log-ins and other configurations from my sql 7.0
I hope someone can help me...
Thanks
December 6, 2004 at 1:45 pm
If you don't have a lot of users, it may be easier to just do it manually, although your database users will be orphaned and will need to be fixed using sp_change_users_login. I have a stored procedure that will create the logins on the new server with the same sid as on the old, preventing orphaned users. There are 3 procedures that I think would get you going, one for logins, one for configuration, and one for custom error messages. To transfer the databases, you can take SQL backups from the 7.0 server and restore those on 2000. The upgrade occurs automatically. You need to be aware that your jobs and DTS packages reside in the MSDB database and will need to be transferred as well. I don't remember what is involved in migrating MSDB. I don't think you can migrate system databases from 7.0 to 2000 the same way that you do user databases. If you have very many jobs/DTS pkgs, it might be worthwhile to investigate migrating the database. Otherwise, you can save the DTS packages as files and copy them to the new server. Open them and save them back to MSDB. You should be able to script the jobs from Enterprise Manager and run those scripts on the 2000 server. I don't use Maintenance Plans, so I don't know what would be involved with them.
Hope this helps,
Steve
edited -
Oh, if you want the procedures that I mentioned, send me a private message, and I'll send them to you.
December 6, 2004 at 3:09 pm
Check the article below.
http://support.microsoft.com/kb/246133#4
You can restore used databases as Steve suggested or also copy the data files from SQL 7.0 to SQL 2000.
December 6, 2004 at 10:26 pm
Thanks, ill try it.
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply