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 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. Does anyone have any better solution? Can the database not be simply exported to a .sql and imported? (I tried but phpmyadmin won't accept the file nor will mysql Thanks. Paul -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org To contact the owner, e-mail: opensuse+owner@opensuse.org