November 30, 2009 at 2:19 am
Hi
I am having SQL 2000 in it 10DB are there i would like to Migrate them to SQL 2005 but not using the migration Wizard.I am just taking the Backup and resote it.
There are N Numser of users are there in each DB i know some of the UserdId and Password,for some i dont know.How to match the users for each DB,each users might have some permissions i too dont know the permissions and userid,password for it.How to get those to update in SQL 2005 is any way there.
Thanks
Parthi
Thanks
Parthi
November 30, 2009 at 2:35 am
parthi-1705 (11/30/2009)
HiI am having SQL 2000 in it 10DB are there i would like to Migrate them to SQL 2005 but not using the migration Wizard.I am just taking the Backup and resote it.
There are N Numser of users are there in each DB i know some of the UserdId and Password,for some i dont know.How to match the users for each DB,each users might have some permissions i too dont know the permissions and userid,password for it.How to get those to update in SQL 2005 is any way there.
Thanks
Parthi
Hi Parthi,
Check the following link
Transfer logins and passwords from SQL Server 2000 to SQL Server 2005
Search here u'll get more info.
Muthukkumaran Kaliyamoorthy
https://www.sqlserverblogforum.com/
November 30, 2009 at 10:15 am
The link provided will help you script out the users and passwords, which you can then run on the new server.
December 1, 2009 at 4:14 am
Hi
I upgraded a lot of SQL 2000 to SQL 2005
1. Remember that the passwords in SQL 2005 are key sensitive - the connection string might need a chagne
2. You need to find all link servers to and from the instance
3. If you got DTS you need to migrate them to SSIS or move them to another SQL 2000
4. dont forget to run best practices (rebuild indexes online, update statistics, recompile objects)
5. You can minumize the down time if you use full and diff/log backups
Good luck!
Guy H
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply