Hi, I am using Microsoft SQL Server with Dot.net MVC application and wanted to migrate the database from SQL Server to Amazon DynamoDB. I was wondering:
Is Dynamo DB feasible with a Dot.Net application? Do we store SQL DB dump file into DynamoDB directly or do we have any third-party tools in the market to restore SQL dump in Dynamo DB? Does Dynamo Db support replication?
Please let me know your answer.
Since you are in a .NET environment; it would possibly be easier to work with SQL Server.
On the other hand your question can't be answered that easily. It depends on how your data is structured or how you planning on structuring it.
SQL Server being a relational database, and DynamoDB being a document based database, both have fundamental differences in how you store and retrieve your data, so this needs to be a consideration in your design.
I'd also like to mention that SQL Server is a server; as to DynamoDB which is a service; replication, scaling, backup all come built in and since it's a managed service, it usually doesn't need your consideration to set this up, it'll just work; costs on DynamoDB might also be something to consider; you pay as you go might be cheap to start with, but might end up being expensive if your application scales; properly defining your reads and writes is a must to keep that in control.
AWS DynomoDB isn't just a different vendor, it's a completely different database architecture. Its a NoSQL database similar to MongoDB. There is no referencial integrity and will require you to redesign your database to be efficient as a NoSQL database. C# isn't just build for MsSQL server. Most databases will have driver support for . NET. DynomoDB has a AmazonDynamoDBClient for .NET. Moving between vendors you might find some tools to help but moving between different