Hi All,
I have an application form employment details, and mostly the data is text & animations. Earlier it was with the MSSQL database. Now I have to migrate it to either PostgreSQL/DynamoD or MongoDB. Could you please help me to choose the correct DB to get the best fit and also can the possibility to migrate from MSSQL the Old records?
Data Types: Text, Animations Source Database: MSSQL Destination Database::? ( DynamoDB/MongoDB/PostgreSQL)
Thanks
Of course both are capable of storing this data and technically possible to migrate to. For rich content that contains lots of different types of content nested together, the flexible structure of a NoSQL like MongoDB even has advantages. However, since you asked, I have to assume that you are less familiar with NoSQL systems and thus recommend the one that is more similar to MSSQL. PostgreSQL is another newer SQL database and would let you keep the old database's structure.
I agree with Martin. PostgreSQL would be easier to migrate to and you can use Microsoft SQL Server Integration Services (SSIS) to easily transfer the data.
