November 8, 2011 at 10:30 am
Hi Folks..
Like to know stretagy for Database Refresh from Production to Other enviornment.
Also if you mention steps and useful Script would be really appreciated.
Have a good day .:-)
November 8, 2011 at 10:36 am
Just use the restore command and put that in a job. Nothing special here.
November 8, 2011 at 10:53 am
what about the users and logins ?
Everytime i have to create new one when do refresh?If you have any ideas or scripts kindly like to know pls.
November 8, 2011 at 11:03 am
logicinside22 (11/8/2011)
Like to know stretagy for Database Refresh from Production to Other enviornment.
it all depends of business requirements which usually include:
1- Frequency - is once a month Okay?... twice a month?
The answer to this question tells you how often it has to be done.
2- Volume - is a full refresh needed or only a subset of the data?
The answer to this question tells you if a full restore would do it or if scripting is needed to select the specific subset.
3- Security, Data - are there confidential information that has to be hidden/scrambled?
The answer to this question tells you if some columns in some tables have to be overwritten with test data, like Credit Card Numbers, SSN, etc.
4- Security, Access - who are the users allowed to access this specific copy of the data?
The answer to this question tells you which accounts have to be dropped, which ones have to be added and what kind of privileges have to be granted to them.
Hope this helps.
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply