Databases
StackOverflow2013
Postsdbo
POMultiple issues using MySQL migration tool
Body
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POMultiple issues using MySQL migration tool
    text
    copied!<p>I am trying to migrate my database from MS SQL 2000 to MySQL using Migration tool in MySQL. When I am doing so, I am getting following warnings:</p> <p>1) Collation changes <code>SQL_Latin1</code> to <code>UTF8_General_CI</code>. I am worried about this as my tables contains encrypted data, does this collateral changes affect that?</p> <p>2) <code>BIT</code> field changes to <code>TINYINT(1)</code>. MySQL has <code>BIT</code> field, than why it is changing to <code>TINYINT</code>?</p> <p>All these were warnings, but also many tables and data are not created. They are missing. So, I picked one table among them, say <code>tblProducts</code>.</p> <p>When I am trying to migrate this table, I am getting following error :</p> <pre><code>Migrating data... wbcopytables.exe --odbc-source=DSN=SwiplODBC;DATABASE=;UID= --target=root@127.0.0.1:3306 --progress --passwords-from-stdin --thread-count=1 --table-file=c:\users\xxxx\appdata\local\temp\tmp5ffenq \users\xxxx\appdata\local\temp\tmp5ffenq `SWIPL11009`.`tblProducts`: Copying 83 columns of 102854 rows from table [SWIPL11009].[dbo].[tblProducts] ERROR: `SWIPL11009`.`tblProducts`:Type mismatch fetching field 40 (should be float, was MYSQL_TYPE_DOUBLE) `SWIPL11009`.`tblProducts`:Finished copying 0 rows in 0m01s 08:43 [INF][ copytable]: Opening ODBC connection to DSN=SwiplODBC;DATABASE=;UID=;PWD=XXX' 08:43 [INF][ copytable]: ODBC connection to 'DSN=SwiplODBC;DATABASE=;UID=;PWD=' opened 08:43 [INF][ copytable]: Connecting to MySQL server at 127.0.0.1:3306 with user root 08:43 [INF][ copytable]: Connection to MySQL opened ***08:43 [WRN][ copytable]: Invalid timestamp literal detected: ''*** </code></pre> <p>Actually I don't have any <code>timestamp</code> field, all are <code>datetime</code>, and set <code>null</code> by default. Looking forward for some suggestion and solutions.</p> <p>Thanks.</p>
 

Querying!

 
Guidance
An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload