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 |
|
gangadhara.ms
Aged Yak Warrior
549 Posts |
 Posted - 2013-01-28 : 02:05:44
|
| Hi Experts .Suggestion for Tools / Techniques for automating the refresh & subsequent configuration of the Microsoft databases (Aim: minimal effort for the DBAs on an ongoing basis to do this)Please suggest any tools/methods which we can do the refresh of the DB very easily.Thanks,Gangadhara MSSQL Developer and DBA |
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2013-01-28 : 11:14:04
|
| SSIS is useful - if you're looking to manage the process. It gives you very granular control .By referesh, do you mean - restoring a copy from backup or do you mean data load?Jack Vamvas--------------------http://www.sqlserver-dba.com |
 |
|
|
gangadhara.ms
Aged Yak Warrior
549 Posts |
Posted - 2013-01-28 : 21:38:34
|
| Its a Data refresh ..copy from backupThanks,Gangadhara MSSQL Developer and DBA |
|
|
|
srimami
Posting Yak Master
160 Posts |
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2013-01-29 : 09:41:59
|
| Have you worked with SSIS ?- that can managed all the stepsAre you attempting to run some DML statements?Jack Vamvas--------------------http://www.sqlserver-dba.com |
|
|
|
|
|
|
Suggestion Tool