OK, it works! Using libreoffice and manually copying the tables worked perfectly. Moodle is now running on the linux server no problems. On 26 April 2016 at 14:08, Paul Groves <paul.groves.787@gmail.com> wrote:
per,
I would but when I output a text file from M$ SQL it comes out as gobledegook M$ format and I cannot view it in anything.
auxsvr,
I linked the table, Access is useless because it only allows me to view / manage / export 255 rows!
Anyway... some progress..,
I created an odbc for the M$ SQL on my workstation. Then installed http://cdn.mysql.com//Downloads/Connector-ODBC/5.3/mysql-connector-odbc-5.3.... then made an ODBC to the new database on the mariadb (MySQL) Server
Opened up two new files in LibreOffice Base, one for each database.
If I drag and drop the tables over (selecting all columns on each one) It moves the data! yay :D and I can see it in phpmyadmin in a readable format! (In UTF-8 too). So I assume libreoffice is doing a select * from table query and then an insert table on the target DB.
Once I have done all 67 tables and moved the moodle files, hopefully it will work fine. I will post back with progress.
See you in a few decades...
On 26 April 2016 at 12:59, Carlos E. R. <robin.listas@telefonica.net> wrote:
On 2016-04-26 13:15, auxsvr wrote:
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.
If my memory doesn't fail me much (I used access ages ago), with access you can open the tables or import (I forget which) into excel. From there, you could dump as csv. Or save and open in Linux with LibreOffice.
-- Cheers / Saludos,
Carlos E. R. (from 13.1 x86_64 "Bottle" at Telcontar)
-- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org To contact the owner, e-mail: opensuse+owner@opensuse.org