Paul Groves wrote:
hi,
I am having trouble migrating a database from M$ SQL to My SQL. The source is a server running MS SQL 2012 R2 and all the server does is run a moodle site. Destination is our opensuse 42.1 web server. running mariadb.
I have tried using the MySQL Workbench, but it fails on most of the data on the Bulk Data Transfer part. It has numerous errors.
Most commonly (with almost all the tables) it says the data already exists at the destination. (It was a brand new database and I have checked with phpmyadmin and there is nothing there!!)
Also it errors with incorrect database encoding. The old database is in Latin General.
I googled that charset a bit, and there seems to be some issues in converting it to UTF-8, see e.g.: http://stackoverflow.com/questions/10124930/encoding-sql-latin1-general-cp1-...
I have tried making a copy (on the ms server) to UTF-8 but this does not work I have also tried using a collation Latin General on the target but it still says it is wrong.
If you can, I would go for UTF-8, it's far more future proof.
Does anyone have any better solution? Can the database not be simply exported to a .sql and imported?
Knowing nothing about M$SQL, it seems to me you ought to be able to export all the data (in the style of mysqldump) to a text file, and then load that into mysql. The data might need some massaging I suppose. -- Per Jessen, Zürich (9.6°C) http://www.hostsuisse.com/ - virtual servers, made in Switzerland. -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org To contact the owner, e-mail: opensuse+owner@opensuse.org