On Tuesday, 26 April 2016 10:13:19 EEST Paul Groves wrote:
you can export the data but it only runs the query and cannot save the file. Alternatively I can general an sql script but the data is unreadable by mysql (and phpmy admin with MSSQL compatibility).
Error messages, please. A data dump from MSSQL may need extra care to import due to line terminator differences. Also, did you try using CHARACTER SET in the dump file, cf. load data[1]?
I have tried multiple migration tools. including MS access Oracle MySQL workbench Oracle mysql migration tool DPRU Database Converter-MS SQL to MySQL
They all error in the ways i mentioned above. (or in the case of DPRU will not even authenticate to MSSQL, and access only works with up to 255 rows and ignores the rest).
Anyone would thing M$ are trying to force you to use their product.... :/
In general, I avoid automated tools to convert databases, because they almost always fail and often mangle data. Did you link or did you import the tables in Access? Importing may fail due to the 2GB size limit. -------- [1] http://dev.mysql.com/doc/refman/5.7/en/load-data.html -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org To contact the owner, e-mail: opensuse+owner@opensuse.org