Solved

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

Posted on 2013-01-18
3
213 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 40

Expert Comment

by:lcohan
ID: 38794707
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 40

Accepted Solution

by:
lcohan earned 500 total points
ID: 38794740
0
 

Author Comment

by:rhservan
ID: 38794930
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

Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Re-appearing SQL Server Agent jobs 7 43
Negative isnull? 3 25
how to restore or keep sql2000  backups useful... 2 28
How come this XML node is not read? 3 31
In this article I will describe the Backup & Restore method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
In this article I will describe the Copy Database Wizard method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …
A short tutorial showing how to set up an email signature in Outlook on the Web (previously known as OWA). For free email signatures designs, visit https://www.mail-signatures.com/articles/signature-templates/?sts=6651 If you want to manage em…

733 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