Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

We have a large Amazon Web Services RDS for SQL Server instance and we would like to do incremental data transfers from RDS to On-Premesis SQL Server on a regular basis.

The On-prem server will be used to feed information into other systems on an acceptable 1-day delay.

However reading through the docs and searching on google, forums etc, we have not found a seamless way to do off-AWS data transfers using RDS for SQL Server.

Built-in SQL Server functions such as Change Data Capture (CDC) are turned off as well as Replication and off-site Backup/Restore services.

Is there a way to do this or is it a limitation of using RDS?

share|improve this question

3 Answers 3

Using SSIS for automation, you may be able to leverage MERGE in lieu of the CDC feature.

share|improve this answer

Best is to load the data into a staging database on premise and then incrementally load the data to the main database.

You can use : SQL Database Migration Wizard found on codeplex.

Even though it is for Azure to onpremise sql server and vice versa, it will work for Amazon RDS as well.

Other alternative is to use SSIS as mentioned by @sqlreader.

share|improve this answer

Import / Export Wizard can do the initial export and import and then you can customize anything you need to in SSIS.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.