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.

 All Forums
 SQL Server 2008 Forums
 SQL Server Administration (2008)
 Suggestion Tool

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 MS
SQL 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
Go to Top of Page

gangadhara.ms
Aged Yak Warrior

549 Posts

Posted - 2013-01-28 : 21:38:34
Its a Data refresh ..copy from backup

Thanks,
Gangadhara MS
SQL Developer and DBA
Go to Top of Page

srimami
Posting Yak Master

160 Posts

Posted - 2013-01-29 : 04:24:56
Please refer to the following link if you are referring to the one mentioned in this link.

http://www.codeproject.com/Articles/233770/AutoRefresh-Entity-Framework-data-using-SQL-Server
Go to Top of Page

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 steps
Are you attempting to run some DML statements?

Jack Vamvas
--------------------
http://www.sqlserver-dba.com
Go to Top of Page
   

- Advertisement -