Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Online Data Transfer Expand / Collapse
Author
Message
Posted Monday, October 14, 2013 8:21 PM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Yesterday @ 12:16 AM
Points: 61, Visits: 406
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.

Post #1504591
Posted Tuesday, October 15, 2013 2:16 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 1:55 PM
Points: 13,253, Visits: 11,033
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).




How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1504639
Posted Wednesday, October 16, 2013 7:40 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, November 14, 2013 10:53 AM
Points: 8, Visits: 45
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.
Post #1505200
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse