Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
newuser001
Starting Member
19 Posts |
 Posted - 2009-05-04 : 15:24:18
|
| We do QA Database Refreshes every 2 or 3 months Process i follow is i generate scripts on the database and get information’s like - Scripting database- Script database users and database roles- Script object level permissions and SQL LoginsThen drop the database data and insert fresh data from production serverI want to right a script or store procedure so that I can schedule a job.... I mean it should be done automatic by just running a script.My idea is : I want to develop a stand-alone application where the DBA will select the Server Name and Database and it should run the script or stored proc so that the fresh data should be loaded to the selected databases.... can this be done?Can you please suggest me some ideas .. on this topic how to automate the refreshes…what do u follow …..??Thanks. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
QA Database Refreshes....