This project is read-only.

Version Metadata not saving

Oct 15, 2012 at 5:06 PM


This is probably because I'm working with a British database but the version metadata is either not being saved or when it is the dates are wrong.

The GetversionUpdateScript method in SqlServers formats the dates to be inserted using "yyyy-MM-dd HH:mm:ss", which today meant that dates looked like this: 2012-10-15 16:03:06.

Unfortunately our instance of SQL Server then throws an error (The conversion of a varchar data type to a datetime data type resulted in an out-of-range value) with this as it confuses the day and month.  This error gets caught by a try catch block which is why I haven't noticed it until now.

last week there was no error, however the last update dates are for the 10th of December and November this year!

I suggest removing the hyphens in the toString calls as I believe "yyyyMMdd HH:mm:ss" works everywhere.

Oct 26, 2012 at 1:10 AM

I took your suggestion and this change will be in the next version. Thanks.