MySQL Forums
Forum List  »  Microsoft SQL Server

Problem with migrating from SQL Server to MySQL
Posted by: Michał Więckowski
Date: September 14, 2018 12:17AM

I've got a problem during migration. To migrate data between SQL Server 2017 and MySQL I use MySQL workbench (version 8.0.12). When script for new tables generation is completed I can find that there are many places where int is set to default value of '', for example:

CREATE TABLE IF NOT EXISTS `myname`.`Table1` (
`version` INT NOT NULL DEFAULT '',
...
)
And this, of course, is not working in next steps. Since I've got 'version' column in each table, is there any way that I can change this globally?

I know that I can go to each table and change it manually but it will be a lot of clicking...

Options: ReplyQuote


Subject
Written By
Posted
Problem with migrating from SQL Server to MySQL
September 14, 2018 12:17AM


Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.