Solved

How do I move data DBs, Tables etc... Every night with SSIS with minimal scrubbing?

Posted on 2013-01-18
3
204 Views
Last Modified: 2016-02-10
Overview:

I don't do much with SSIS but we have a need to copy data from SQL servers in LA
To Denver nightly.

How can I use SSIS to grab changed data and place in another DB in Denver.

The LA SQL servers are accessible through our intranet.
0
Comment
Question by:rhservan
  • 2
3 Comments
 
LVL 39

Expert Comment

by:lcohan
Comment Utility
In my oppinion you should look at Log Shipping and more details at link below. Basicaly you take a full backup at source enable log shipping, restore at destination then just "ship"/restore the T-logs.

http://msdn.microsoft.com/en-us/library/ms187103(v=sql.100).aspx
http://msdn.microsoft.com/en-us/library/ms190640(v=sql.100).aspx


from the destination db you can then read (only) data that you need.
0
 
LVL 39

Accepted Solution

by:
lcohan earned 500 total points
Comment Utility
0
 

Author Comment

by:rhservan
Comment Utility
Okay,  I like the export, option 2 in the above link.  But it seems to work with all data,   how do i get just the new or changed data.  And I want to run every night fully automated.
0

Featured Post

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

SQL Server  2012 Release with lots of Enhancements in Database Engine functions, SSIS, SSRS and some of new services like Data Quality Server and Master Data Service. Of particular interest, and the focus of this Article is SSIS. So, time to elab…
Over the last 2 years, I have been working on SSIS 2008. Really the tough tasks in SSIS are to deploy packages and pass parameters (Values from outside package). The latter is certainly a headache for developers, particularly for me. We had to ma…
Illustrator's Shape Builder tool will let you combine shapes visually and interactively. This video shows the Mac version, but the tool works the same way in Windows. To follow along with this video, you can draw your own shapes or download the file…
This video gives you a great overview about bandwidth monitoring with SNMP and WMI with our network monitoring solution PRTG Network Monitor (https://www.paessler.com/prtg). If you're looking for how to monitor bandwidth using netflow or packet s…

763 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

7 Experts available now in Live!

Get 1:1 Help Now