Comments
Sort by recent activity
David,
Here is what was in one of the date columns:
-29762-12-16 499:03:07.627
I would say it is "special"! This happened on a development server so we don't know how this data was created.
Dave / comments
David,
Here is what was in one of the date columns:
-29762-12-16 499:03:07.627
I would say it is "special"! This happened on a development server so we don't know how this data was created.
Dave
We experienced this exact error today and we have the .NET Framework 2.0 installed on the workstation. We still have a copy of 4.0 and it reported an invalid date problem. We found that somehow we did get an invalid date in row. After removing the one row SQL Data Compare 5 was able to compare and update the tables.
Perhaps this is the real issue?
Dave / comments
We experienced this exact error today and we have the .NET Framework 2.0 installed on the workstation. We still have a copy of 4.0 and it reported an invalid date problem. We found that somehow w...
Hi Brian,
Yes, I should have posted under Data Compare. Thanks for logging this as an improvement for a later version...5.30 I hope!
Thanks,
Dave / comments
Hi Brian,
Yes, I should have posted under Data Compare. Thanks for logging this as an improvement for a later version...5.30 I hope!
Thanks,
Dave
I get the same results either way.
Thanks,
Dave / comments
I get the same results either way.
Thanks,
Dave
Hi Brian,
I found the problem in the SQL Data Compare product but did duplicate the issue in the SQL Compare product. I can check the "Treat items as case sensitive" box under Behavior in the Options tab using SQL Compare and the compare will complete successfully so I guess there is no problem in SQL Compare. However, I don't see an "Ignore User Property" option in the SQL Data Compare product and this is the product we use the most.
Yes, it appears to not be checking the case sensitivity for user names and it needs to check case. Perhaps Ignore case needs to be added to the Comparison Behavior section under the Options Tab when a Project is configured in SQL Data Compare? Does this mean you will open a job to fix the issue?
Thanks,
Dave / comments
Hi Brian,
I found the problem in the SQL Data Compare product but did duplicate the issue in the SQL Compare product. I can check the "Treat items as case sensitive" box under Behavior in the Opti...
Brian,
I can get to the options tab and the 'ignore case' option is already checked.
Dave / comments
Brian,
I can get to the options tab and the 'ignore case' option is already checked.
Dave