I have a SQL Server 2012 hosted on a standalone machine. I want to migrate it to my AWS Redshift (already existing data warehouse).

My question is wether it is possible via AWS Data migration service ?

I am also open to other efficient methods for migration. Currently I am doing the following steps

  1. taking a backup of the SQL server DB in the standalone server.
  2. uploading it to AWS-S3.
  3. Droping and restoring the Db from S3 in AWS-RDS (Sql-server)

I would like this data to be present in my data warehouse i.e AWS-Redshift

  • i answered your duplicate question on SO yesterday and you did not reply! stackoverflow.com/questions/48781844/… – Jon Scott Feb 15 '18 at 20:35
  • Hi @Jon, as the question was asked here first, perhaps you would consider answering here too? It's a pretty good fit for this site. – Jack Douglas Feb 16 '18 at 14:50
  • ok done, i wonder if i will get a response from the poster – Jon Scott Feb 16 '18 at 15:15

There are 2 types of migration within DMS

  1. "one off" data migration, where the data is copied using sql statements
  2. "continuous replication", where the "change dta capture" system on the source is used to capture and process just the updates.

SQL server can be used as a source for both of these types however there are caveats and limitations that should be read and understood thoroughly.


So long as you follow the instructions and meet the limitiations that are documented then it will work great.

| improve this answer | |

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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