search

AzureCosmosDB / data-migration-desktop-tool

MIT License
122 stars 46 forks source link

ISO-8601 Date Format String is Changed After Data Migration #103

Open dicksonlee-harmonicinc opened 8 months ago

dicksonlee-harmonicinc commented 8 months ago

We are trying to migrate data from cosmosdb container A to B using the tool, one of the fields of the record is a ISO-8601 string as follows:

{
  "event_time": "2023-12-19T00:00:00.000Z"
}

However, after migrating to container B, the record is saved as follows:

{
  "event_time": "2023-12-19T00:00:00Z"
}

the content of event_time is changed, which is not expected. We found a similar issue reported before: https://github.com/AzureCosmosDB/data-migration-desktop-tool/issues/36

khlamat commented 8 months ago

Same here, I performed data migration using Release 2.1.4 and found that the data lost the millisecond precision. Is it possible to have an option to keep the date format?