Per, 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). auxsvr, 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.... :/ Very stumped here.... are there any official migration processes? (that work because oracle's or MS's do not actually transfer the data, only the schema). On 26 April 2016 at 09:46, auxsvr <auxsvr@gmail.com> wrote:
On Tuesday, 26 April 2016 09:23:36 EEST 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 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
One option is to use a program to connect to both databases and write queries to copy the data manually via ODBC or JDBC. One such program is MS Access.
Thanks.
Paul -- Regards, Peter -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org To contact the owner, e-mail: opensuse+owner@opensuse.org
-- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org To contact the owner, e-mail: opensuse+owner@opensuse.org