Description:
Trying to copy tables with the migration wizard fails if the SQL Server source datatype is FLOAT(53).
The target schema states correctly target type Double but the migration fails.
Log
Starting...
Prepare information for data copy...
Prepare information for data copy done
Determine number of rows to copy....
Counting number of rows in tables...
wbcopytables.exe --count-only --passwords-from-stdin --odbc-source=DSN=sqlserver;DATABASE=;UID=raumtalk --table-file=c:\users\ggr\appdata\local\temp\tmphxarsw
14:10:05 [INF][ copytable]: --table [MigrationTest] [dbo].[testdouble]
14:10:05 [INF][ copytable]: --table [MigrationTest] [dbo].[testfloat]
14:10:05 [INF][ copytable]: --table [MigrationTest] [dbo].[testfloat2]
14:10:05 [INF][ copytable]: Opening ODBC connection to 'DSN=sqlserver;DATABASE=;UID=raumtalk;PWD=XXX'
14:10:05 [INF][ copytable]: ODBC connection to 'DSN=sqlserver;DATABASE=;UID=raumtalk;PWD=' opened
3 total rows in 3 tables need to be copied:
- [MigrationTest].[dbo].[testdouble]: 1
- [MigrationTest].[dbo].[testfloat]: 1
- [MigrationTest].[dbo].[testfloat2]: 1
Determine number of rows to copy finished
Copy data to target RDBMS....
Migrating data...
wbcopytables.exe --odbc-source=DSN=sqlserver;DATABASE=;UID=raumtalk --target=root@localhost:3306 --progress --passwords-from-stdin --thread-count=2 --table-file=c:\users\ggr\appdata\local\temp\tmpodlz9z
\users\ggr\appdata\local\temp\tmpodlz9z
`dbo`.`testdouble`:Copying 1 columns of 1 rows from table [MigrationTest].[dbo].[testdouble]
ERROR: `dbo`.`testdouble`:Type mismatch fetching field 1 (should be float, was MYSQL_TYPE_DOUBLE)
`dbo`.`testdouble`:Finished copying 0 rows in 0m00s
`dbo`.`testfloat`:Copying 1 columns of 1 rows from table [MigrationTest].[dbo].[testfloat]
ERROR: `dbo`.`testfloat`:Type mismatch fetching field 1 (should be float, was MYSQL_TYPE_DOUBLE)
`dbo`.`testfloat`:Finished copying 0 rows in 0m00s
`dbo`.`testfloat2`:Copying 1 columns of 1 rows from table [MigrationTest].[dbo].[testfloat2]
`dbo`.`testfloat2`:Finished copying 1 rows in 0m00s
10:05 [INF][ copytable]: --table [MigrationTest] [dbo].[testdouble] `dbo` `testdouble` [Value]
10:05 [INF][ copytable]: --table [MigrationTest] [dbo].[testfloat] `dbo` `testfloat` [Value]
10:05 [INF][ copytable]: --table [MigrationTest] [dbo].[testfloat2] `dbo` `testfloat2` [Value]
10:05 [INF][ copytable]: Opening ODBC connection to 'DSN=sqlserver;DATABASE=;UID=raumtalk;PWD=XXX'
10:05 [INF][ copytable]: ODBC connection to 'DSN=sqlserver;DATABASE=;UID=raumtalk;PWD=' opened
10:05 [INF][ copytable]: Connecting to MySQL server at localhost:3306 with user root
10:06 [INF][ copytable]: Connection to MySQL opened
10:07 [INF][ copytable]: Opening ODBC connection to 'DSN=sqlserver;DATABASE=;UID=raumtalk;PWD=XXX'
10:07 [INF][ copytable]: ODBC connection to 'DSN=sqlserver;DATABASE=;UID=raumtalk;PWD=' opened
10:07 [INF][ copytable]: Connecting to MySQL server at localhost:3306 with user root
10:08 [INF][ copytable]: Connection to MySQL opened
Copy helper has finished
Data copy results:
- `dbo`.`testdouble` has FAILED (0 of 1 rows copied)
- `dbo`.`testfloat` has FAILED (0 of 1 rows copied)
- `dbo`.`testfloat2` has succeeded (1 of 1 rows copied)
1 tables of 3 were fully copied
Copy data to target RDBMS finished
Tasks finished with warnings and/or errors, view the logs for details
Finished performing tasks.
How to repeat:
Create Tables in MS SQL Server:
use MigrationTest;
go
CREATE TABLE testfloat
(
Value FLOAT
);
CREATE TABLE testdouble
(
Value DOUBLE PRECISION
);
CREATE TABLE testfloat2
(
Value FLOAT(7)
);
INSERT INTO testfloat (Value) VALUES (1.05);
INSERT INTO testdouble (Value) VALUES (1.05);
INSERT INTO testfloat2 (Value) VALUES (1.05);
Now try to migrate the tables to MySQL using workbench 5.2.44 will fail because of type mismatch.