Friday, March 9, 2012

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.

No comments:

Post a Comment