Type conversion

Simple solution that fully automates the process of data import, export or migration

Moderator: Support Team

Type conversion

Postby Vik » Tue Aug 09, 2011 5:06 am

I want to copy my table from SQL Server to MySQL.
When the program copy table definition I got "unknown datatype 11" error for datetime column.
Any suggestion?
Vik
 

Re: Type conversion

Postby Support Team » Tue Aug 09, 2011 5:14 am

Vik, 2008 version of the MS SQL uses "datetime2" data type even you create it as "datetime".
As workaround we recommended to add "datetime2" to "datetime" data type mapping item to your migration rule.
Support Team
 
Posts: 256
Joined: Sun Mar 26, 2006 3:48 pm


Return to DTM Migration Kit

Who is online

Users browsing this forum: No registered users and 2 guests

cron