Re: Workbench 5.2: No field data integrity check???

[Mike Lischke]

Shirley,

this scenario sounds like there's no single import-reverse engineer-refactor-apply solution. If you have a large amount of different csv files and this task is recurring then it might be better to write an import application/script that can take csv data in various formats and imports that directly into an existing (already optimized) database. That will take quite some grief from you but might not be possible if have no way to create such an import application/script.

Mike

Mike Lischke, MySQL Developer Tools
Oracle Corporation

MySQL Workbench on Github: https://github.com/mysql/mysql-workbench
On Twitter: https://twitter.com/MySQLWorkbench
On Slack: mysqlcommunity.slack.com (#workbench)
Report bugs to http://bugs.mysql.com
MySQL documentation can be found here: http://dev.mysql.com/doc/refman/8.0/en/