Data compare finished without issue. Then ran Synchronization Wizard to create the update script to make target like source. The script fails when attempting to execute on the target because the dates are not quoted.
E.g.
Script create:
UPDATE [DBA].[Form_One]
SET [Exp_Date] = 2015-05-31 12:00:00 AM
Expected:
UPDATE [DBA].[Form_One]
SET [Exp_Date] = '2015-05-31 12:00:00 AM'
WORKAROUND:
None.
Manually edit date format.
STATUS:
Fixed in current version, 4.0 of Toad Data Point
© ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center