Transform from MSSql to MySql. Mysql.

The conversion is: MSSQL -> VFP -> MySQL. We provide - scripts to create the MySQL DB - an export MSSQL -> VFP - an export VFP -> MySQL

The main steps for you to do are: 1. install a MYSQL server 2. setup a MySQL database 3. create a database user 4. create the OPAS MySQL DB 5. convert your data to MySQL

But: in a MySQL dump, you can have data or data and structure. In the second case, the MySQL dump usually creates the MySQL scheme (step 4) – in this case there’s no need to create it separately beforehand.

On the server: - you’ll need an ODBC Driver (MySQL ODBC 5.3 ANSI Driver) - in the .ini you’ll have to 1. change the DBType (=MySQL) and 2. modify the ODBC connect string - and if you have OPAS Online, you need the same connect string in the uploadxml.cfg .

On every workstation: - you’ll need to install the ODBC driver and - configure the ODBC connection like the one the server.

We support: MySQL >= version 5.6 and Maria DB version 10.

Having a tool like HeidiSQL or MySQL Workbench can be advantageous.

/Woelbitsch