Migration

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » Administering » Migration

Migration

Rate Topic

Display Mode

Topic Options

Author

Message

parthi-1705

Posted Monday, November 30, 2009 2:19 AM

Mr 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

muthukkumaran Kaliyamoorthy

Posted Monday, November 30, 2009 2:35 AM

Ten Centuries

Group: General Forum Members
Last Login: Tuesday, May 21, 2013 5:22 AM
Points: 1,123, Visits: 4,423

parthi-1705 (11/30/2009)

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

Steve Jones - SSC Editor

Posted Monday, November 30, 2009 10:15 AM

SSC-Dedicated

Group: Administrators
Last Login: Yesterday @ 3:30 PM
Points: 31,436, Visits: 13,751

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

guy.hochman

Posted Tuesday, December 01, 2009 4:14 AM

Forum 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 »

Permissions