migration to sql 2005

Hi

I am doing sql 2000 to 2005 migration.

I am following the back up and restore method to do the migration.

After migration i run a script to transfer logins and passwords from sql 2000 to sql 2005 as in http://support.microsoft.com/kb/246133/

After migration I need to assign a database role created to a login /user .I need to do this through scripting.

Please help me on how to do this through script .

Thanks

You can script the permission in SQL 2000 and use the same in SQL 2005 for such requirement.

migration from sql 2000 to sql 2005

Hi there i am about to do the same thing back and restore.

As for the logins im used to the sp_help_revlogin.

Which i have done from SQL 2000 to another SQL 2000

Is this script safe to run in SQL 2000 then get the script and just run in SQL 2005. I was under the impression there are different sys files.

Thanks

You might find a review of these articles to be useful.

Moving Server/Database/Logins
http://vyaskn.tripod.com/moving_sql_server.htm Moving DBs
http://msdn2.microsoft.com/en-us/library/ms345408(en-US,SQL.90).aspx Moving system dbs 2005
http://www.databasejournal.com/features/mssql/article.php/3379901 Moving system DB's 2000
http://www.support.microsoft.com/?id=314546 Moving DB's between Servers
http://www.support.microsoft.com/?id=224071 Moving SQL Server Databases to a New Location with Detach/Attach
http://www.support.microsoft.com/?id=221465 Using WITH MOVE in a Restore
http://www.sqlservercentral.com/columnists/cBunch/movingyouruserswiththeirdatabases.asp Moving Users
http://www.support.microsoft.com/?id=246133 How To Transfer Logins and Passwords Between SQL Servers
http://support.microsoft.com/default.aspx?scid=kb%3ben-us%3b918992 Logins between instances of SQL Server 2005
http://www.support.microsoft.com/?id=298897 Mapping Logins & SIDs after a Restore
http://www.dbmaint.com/SyncSqlLogins.asp Utility to map logins to users
http://www.support.microsoft.com/?id=168001 User Logon and/or Permission Errors After Restoring Dump
http://support.microsoft.com/kb/274188 Troubleshooting Orphan Logins
http://www.support.microsoft.com/?id=240872Resolve Permission Issues -Database Is Moved Between SQL Servers
http://www.sqlservercentral.com/scripts/scriptdetails.asp?scriptid=599 Restoring a .mdf
http://www.support.microsoft.com/?id=307775 Disaster Recovery Articles for SQL Server
http://www.support.microsoft.com/?id=320125 Moving a Diagram
http://www.support.microsoft.com/?id=274463 Copy DB Wizard issues 2000
http://www.sqlservercentral.com/scripts/contributions/1598.asp Script Roles and Permissions
http://sqljunkies.com/HowTo/B9F7F302-964A-4825-9246-6143A8681900.scuk Move Tables to New Files