Solved

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

Posted on 2013-01-18
3
211 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
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 39

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

Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
sql query questions 2 35
MS SQL Delete Query 9 33
SQL Server Count where two id types exist in column 8 27
SQL Server - Set Field Values ito Zero Based on Related Table 4 28
In couple weeks ago, I encountered an extremely difficult problem while deploying 2008 SSIS packages to a new environment (SQL Server 2014 standard).  My scenario is: We have one C# application that is calling 2008R2 SSIS packages to load text fi…
Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
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…

832 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