May 9, 2009 at 12:20 am
Hi all,
How can i migrate the roles form Sql server 2000 to 2005?
Ramaprasad.
May 10, 2009 at 2:48 am
prasadrandi (5/9/2009)
Hi all,How can i migrate the roles form Sql server 2000 to 2005?
Ramaprasad.
Script out the logins and execute them against your 2005.
Check this out which is handy:
May 11, 2009 at 2:25 am
Google should find you a few scripts that can do this.
Also, SQL Server FineBuild on Codeplex has scripts to help you transfer logins and roles from SQL 2000 to SQL 2005 and 2008.
Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.
When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara
May 12, 2009 at 8:05 am
Here is a rather quick'n'dirty script that we use.
RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."
May 12, 2009 at 8:29 am
http://vyaskn.tripod.com/scripting_permissions_in_sql_server_2005.htm
[font="Comic Sans MS"]+++BLADE+++[/font]:cool:
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply