October 14, 2013 at 8:21 pm
Hi,
In my company i am facing following problem.please i want good solution.
We are following three environments of server.
1) development 2) Testing 3) Production
In my questions is i want move the data from production server to testing server daily basis.In my project we are using more then 600 tables. what are all the changes happened in production server ,it should be affect testing environment.I dont want current data.One day previous data enough.
October 15, 2013 at 2:16 am
You can create an ETL solution using SSIS to truncate the test server and get the latest day from the production server.
600 tables will be quite some work, but you could use views in the production server or use a dynamic method to import the data (for example looping over the tables and generating dynamic SQL queries to select the data needed).
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
October 16, 2013 at 7:40 am
Hello,
Have a look at any MS SQL related Sync software. Just set up MS SQL as source and target database.
You can schedule sync job running daily.
Trigger based sync reflects changes made in one databases to another databases.
Bidirectional db sync is available as well.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply