Jim Bonnie's Blog

Jul 17

Written by: jbonnie
Monday, July 17, 2006 3:00:23 AM 

Migrating databases between production and development machines can be a challenge at times.
I just ran into another complication for user accounts.
When migrating databases, you probably are migrating the database and security information contained in it. You may not have the same users defined at the top level database level.

If you simply try to create database users with the same names, you will run into problems. The new top level users will not have the same internal ID as the user defined in the moved database.
Microsoft has a KB article on this, that shows how to migrate the database users along with the databases, the article for SQL 2005 is at How to transfer the logins and the passwords between instances of SQL Server 2005

The KISS method for smaller development shops, is to just use different login names.
After migrating the database, simply add a username to the moved database that already exists on the machine and you will be fine.

The offical method could be important for larger shops that try to mirror production and integration testbeds.

Tags:

Your name:
Your email:
(Optional) Email used only to show Gravatar.
Your website:
Title:
Comment:
Add Comment   Cancel 

Navigation

Register Login

About Me

Thanks for stopping by. My name is Jim Bonnie and I have been writing software for over 20 years. After building financial data systems for Reuters for nearly 18 years I have started doing contract work and am excited about technology and currently focus on Microsoft solutions. DotNetNuke has helped provide a good introduction to ASP.NET web application development, and I am now starting to branch out into other areas. Data Access techniques and SubSonic is something that I am looking into now. This has helped me get an invitation to speak at Las Vegas at DNN Open Force 07. it was a great time. And I am looking forward to OpenForce08, where I wil be presenting on TDD for DNN.

 

Reading the codebetter blogs and attending a nothing but .net training class with JP Boodhoo helped spark my interest in ALT.NET. I attended the first conference in Austin Texas, and it was amazing to see Scott Guthrie introduce the ASP.NET MVC framework.

Add to Technorati Favorites

View blog top tags

Links

Jim Bonnie's Blog

Jim Bonnie's Blog

Jim Bonnie's Blog