automating SQL Server database refresh
-
Hi all
I'm able to create a job to refresh test1,test2 and test3 databases with testA,testB and testC databases by taking a backup of A,B and C and restoring them at required intervals but I'm not sure how I can refresh 1,2 and 3 with A,B and C without backups (baseline) i.e. i want to automate the process of refreshing 1,2 and 3 with A,B and C everyday without taking a baseline of A,b and C which involves setting up a job to automatically refresh 1,2 and 3 every evening with A,B and C.
-
Have you looked at creating a DTS package? You can copy tables, users and other objects from one database to another.
John
-
my 2 C, Other than backup, I can think of having a scheduled package which transfers the data after cleaning previous data. I am not sure how many tables and data you need to move from 1,2,3 to A,B,C.
-B
-
I know scheduling a package should work but I've been tasked with scheduling as a backup/restore process
-
how about Log-shipping?
-
log shipping a no no
-
Log shipping is a nice way of "backup/restore"
-
Have you considered using restore with 'standby'. It could only be used as read-only though. See BOL
-
Are the source databases (A,B,C) on a different server than the destination databases (1,2,3)? What exactly do you mean by "refresh"? Does that mean you want to replace all the data in all the tables with new data every day or do you want to restore a full backup, then keep them in sync by restoring log backups?
IMO, DTS is by far the easiest way to move data. Not being able to use it is like only being allowed to use one tool in your toolbox.
Greg
Greg
Viewing 9 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply