Refresh Dev Data with Production Data

[saw15]

I need to refresh the development data from production about once a week. Problem, is that there are mulitple id's created on the development side with differenct user id's & passwords.

I refresh the dev data by creating a backup of the production data, copying it over, and then restoring the backup.

This eliminates any and all of the different logins on the development db.

What is the best way to get around this? Recommendations appreciated, am a SQL Server newbie.

 

[bperry]

I don't look after admin issues on our servers, but it sounds like the answer to login/password problems might be here:

http://www.swynk.com/friends/boyle/fixingbrokenlogins.asp

 

[tlbroadbent]

You should script the users. Then run the script after restoring the database.

The link provided by bperry is great if the users exist on the restored DB but are not synched with the logins on the development server. If the users don't exist, you need to create them. The easiest way to do that is through a script. Terry L. Broadbent - DBA
Computing Links:

http://tlbroadbent.home.attbi.com/prog.htm

faq183-874 contains "Suggestions for Getting Quick and Appropriate Answers" to your questions.

 

[bperry]

tb:
I had to read that three times to see what you were talking about. Now I get it.