This project has moved and is read-only. For the latest updates, please go here.


There was an error in part of the date format.


Latest version of SSC Toolbox giving error in converting SQL Server to SQL Server Compact.

Attached is the screenshot for reference.

file attachments

Closed Jul 23, 2016 at 7:31 PM by ErikEJ


ErikEJ wrote Jul 21, 2016 at 12:33 PM

Could you try the option: Preserve values of unsupported SQL server date types

kaushalpanchal42 wrote Jul 22, 2016 at 5:24 AM

Thanks Erik for Help. It worked. :-) :-)

Thanks Again,

ErikEJ wrote Jul 23, 2016 at 7:31 PM

The core of the issue is that I try to script datetime2/datetimeoffset as datetime, but some value is outside the allowable range for datetime 1753 - 9999

wrote Jul 23, 2016 at 7:31 PM