Hi, We are having issues with a synchronization project using a native database connector, the target system will not show any fields that are Datetime2(7).
A few of the sql server database tables has many fields that are Datetime2(7) and when we connect to the tables using the synchronization editor those fields will not show up at all. We tried to troubleshoot this by creating a dummy table with a few fields as Datetime and a few as Datetime2(7). The fields that were just Datetime showed up but none of the Datetime2(7). We are unable to change the datatype on the target side as this is not in our control.
Can someone please shed some light into this issue and if there is a workaround?
Thanks in advance.
