Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Migration Expand / Collapse
Author
Message
Posted Monday, November 30, 2009 2:19 AM


Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Wednesday, December 26, 2012 11:03 PM
Points: 586, Visits: 2,195
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
Post #826056
Posted Monday, November 30, 2009 2:35 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Monday, October 13, 2014 7:16 AM
Points: 1,159, Visits: 4,656
parthi-1705 (11/30/2009)
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


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

Helping SQL DBAs and Developers >>>SqlserverBlogForum
Post #826066
Posted Monday, November 30, 2009 10:15 AM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: Yesterday @ 12:34 PM
Points: 31,181, Visits: 15,626
The link provided will help you script out the users and passwords, which you can then run on the new server.






Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help
Post #826344
Posted Tuesday, December 1, 2009 4:14 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Sunday, February 20, 2011 8:38 AM
Points: 2, Visits: 61
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
Post #826554
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse