1

Closed

There was an error in part of the date format.

description

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 6:31 PM by ErikEJ

comments

ErikEJ wrote Jul 21, 2016 at 11:33 AM

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

kaushalpanchal42 wrote Jul 22, 2016 at 4:24 AM

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

Thanks Again,
Karn

ErikEJ wrote Jul 23, 2016 at 6: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 6:31 PM