Forum Discussion
SSMA For Access not recognising DateTime/Extended fields
Can you provide a small repro accdb with the required tables and fields?
Also, can you specify which version of SSMA you are using? "Current" meaning?
I see that you did provide a repro accdb in the other post.
There is no way to add the new, previously defined datatype DateTimeExtended, in SSMA. Maybe there's another workaround, but it sure does look like converting the datatype in Access is the way it will need to be done to support migration, even though SQL Server supports DateTime(2).
Hi George,
Just for information - I'm using SSMA version 10.2
The work arounds are fine for smaller projects but on a large migration would be a massive extra workload, especially if you were frequently replacing the data from a live environment during development, assuming you couldn't change the data types in the live system.I have the same version.
I opened an issue for this missing datatype in the SSMA GitHub, using the Feedback option under Help in SSMA.
https://github.com/microsoft/SSMA/issues/20Perhaps you can add a comment documenting the hurdles you face because of this ommission. I can see how this will become an even bigger issue as more people adopt the DateTimeExtended option.
