unable to restore backup on MSSQL : datetime convert
Hi,
I have a fresh backup from a SD+ 6 (build 6003) with mysql database.
I tried to change database on MSSQL (seems to be ok) and restore the backup...
and it failed at 60% with (in french):
Writting PdfUIComponent.sql
Writting PdfViewConfig.sql
Writting Periodic.sql
La conversion d'un type de données CHAR en type DATETIME a donné une valeur hors limite de date et d'heure.
apparently date format in mysql are a char and datetime in MSSQL. is there a workaround.
I have a fresh backup from a SD+ 6 (build 6003) with mysql database.
I tried to change database on MSSQL (seems to be ok) and restore the backup...
and it failed at 60% with (in french):
Writting PdfUIComponent.sql
Writting PdfViewConfig.sql
Writting Periodic.sql
La conversion d'un type de données CHAR en type DATETIME a donné une valeur hors limite de date et d'heure.
apparently date format in mysql are a char and datetime in MSSQL. is there a workaround.