Visa wikitext

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

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

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.<br><br>

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

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


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

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

/Woelbitsch