Hello ,
We are evaluating mongodb relational migrator tool and we want to migrate from Azure SQL to mongodb atlas by making columns as dynamic key value pairs . We have enabled CDC and it is migrating but I cannot transform columns to key value pairs like shown below
Eg: Azure SQL
{ “ID”: “123”, “att1”: “a”, “name”: “blah blah”, “att2”: “b”, “count”: 45 }
to Target(MongoDb Atlas)
{“ID”: “123”,“attributes”: [{ “key”: “att1”, “value”: “a” },{ “key”: “name”, “value”: “blah blah” },{ “key”: “att2”, “value”: “b” },{ “key”: “count”, “value”: 45 }]}