3

I have a database in PostgreSQL. Now we need to import whole database into DynamoDB. Data Migration service need to be used for this purpose or any other service can be used. Please explain in detail.

What is the strategy to be followed? I have studied many blogs but I couldn't get any proper way to migrate the whole database from PostgreSQL to DynamoDB. Only through DMS Service is it possible to migrate or any other service can be used to migrate or any script should be run to migrate the PostgreSQL to to DynamoDB.

John Rotenstein
  • 241,921
  • 22
  • 380
  • 470
samiksha p
  • 51
  • 1
  • 6
  • 4
    Are you sure you wish to do this? DynamoDB is _not_ a relational database, so the application that uses the data would need to be rewritten. You would also likely want to change the way that the data is stored. Have your application developers created a proof-of-concept against a subset of the data to confirm that it will be useful? – John Rotenstein Apr 17 '19 at 07:23
  • @John Rotenstein Ya...everything is done....we are trying to migrate the Whole DB from PostgreSQL to dynamo DB...It is very tedious...we are not sure which service to use and how to use it..please help me – samiksha p Apr 17 '19 at 07:27
  • @ John whether it is possible to migrate the whole db from postgreSQL to synamo DB? – samiksha p Apr 17 '19 at 07:29
  • Well, if the AWS Data Migration Service can do it, then that sounds like a good idea. Did you have a problem with it? – John Rotenstein Apr 17 '19 at 07:35
  • Ya...I don't know where to start how to do that...I didn't find the full tutorial to do that..Please help me... – samiksha p Apr 17 '19 at 07:38
  • @John we are trying hard to do that...please help us to do that – samiksha p Apr 17 '19 at 07:41
  • 1. [Getting Started with AWS Database Migration Service](https://docs.aws.amazon.com/dms/latest/userguide/CHAP_GettingStarted.html) 2. [Using a PostgreSQL Database as a Source for AWS DMS](https://docs.aws.amazon.com/dms/latest/userguide/CHAP_Source.PostgreSQL.html) 3. [Using an Amazon DynamoDB Database as a Target for AWS Database Migration Service](https://docs.aws.amazon.com/dms/latest/userguide/CHAP_Target.DynamoDB.html) – John Rotenstein Apr 17 '19 at 07:42
  • @John The links are complete tutorial? If i face any problem i will reach out to u ...pls help me – samiksha p Apr 17 '19 at 07:46
  • @John Is there any specific type of file extension....only that can be imported into the dynamo db or...what is the format that can be imported into the db – samiksha p Apr 17 '19 at 09:14

1 Answers1

1

The AWS Database Migration Service offers everything you would need to migrate data from any relational DB into AWS - whether the target is DynamoDB (NoSQL offering from AWS) or any of the DB flavors from AWS RDS service.

You can find multiple migration playbooks and step-by-step guides on the Resources page of this AWS service

azec-pdx
  • 4,790
  • 6
  • 56
  • 87