MySQL migration error: invalid tag timeout detected

Question

I am trying to migrate a MS SQL 2008 R2 database to MySQL 5.6 CE. I am using MySQL WorkBench 5.2. The migration ended with the number of errors.

Most errors:

[WRN] [copytable]: An invalid tag timeout was detected: ''.

This error message does not make sense because the DateTime column is not specified in the table. For example, he tried to wrap 4 rows of data from this table:

 /****** Object: Table [dbo].[defResidentialStatus] Script Date: 07/11/2013 14:33:47 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[defResidentialStatus]( [idResStatusKey] [int] IDENTITY(1,1) NOT NULL, [desc1] [nvarchar](50) NOT NULL, [desc2] [nvarchar](50) NOT NULL, [active] [bit] NOT NULL, CONSTRAINT [PK_defResidentialStatus] PRIMARY KEY CLUSTERED ( [idResStatusKey] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] GO ALTER TABLE [dbo].[defResidentialStatus] ADD CONSTRAINT [DF_defResidentialStatus_active] DEFAULT ((1)) FOR [active] GO 

This log is as follows:

TestDB . defResidentialStatus : copy 4 columns of 4 rows from the table [TestDB]. [DBO]. [DefResidentialStatus]

''

04:33 [WRN] [copy]: Invalid time limit detected: ''

04:33 [WRN] [copy]: Invalid time limit detected: ''

04:33 [WRN] [copy]: Invalid time limit detected: ''

04:33 [WRN] [copy]: Invalid time limit detected: ''

04:33 [WRN] [copy]: Invalid time limit detected: ''

<<<Repeat the same error message about 40 times, not including space →>

04:34 [WRN] [copyPROGRESS: TestDB . defResidentialStatus : 4: 4 ............. TestDB . defResidentialStatus has FAILED (0 of 4 lines copied)

I have no idea what is going on. This is a very simple table with 4 columns and 4 rows. This is not the only table returning this type of error, but one of the simplest.

The data in the table:

 1 Pending Pending 1 2 Arrived Arrived 1 3 Cancelled Cancelled 1 4 Departed Departed 1 

Answer 1

Datetime - in MYSQL, datetime does not contain milliseconds. The SQL Server datetime datatype is milliseconds. Error: Invalid time limit error. Converting datetime to smalldatetime in SQL Server, if you don't mind losing milliseconds.

Here is the code to convert:

 SELECT CONVERT(smalldatetime,<columnName>); 

After conversion, you should not import it.