Transform from MSSql to MySql. Mysql.
(Skapade sidan med '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. ins...') |
|||
| Rad 1: | Rad 1: | ||
| − | The conversion is: MSSQL -> VFP -> MySQL. | + | The conversion is: MSSQL -> VFP -> MySQL.<br><br><br> |
| − | We provide | + | We provide <br> |
| − | - scripts to create the MySQL DB | + | - scripts to create the MySQL DB<br> |
| − | - an export MSSQL -> VFP | + | - an export MSSQL -> VFP<br> |
| − | - an export VFP -> MySQL | + | - an export VFP -> MySQL<br><br> |
| − | The main steps for you to do are: | + | The main steps for you to do are:<br> |
| − | 1. install a MYSQL server | + | 1. install a MYSQL server<br> |
| − | 2. setup a MySQL database | + | 2. setup a MySQL database<br> |
| − | 3. create a database user | + | 3. create a database user<br> |
| − | 4. create the OPAS MySQL DB | + | 4. create the OPAS MySQL DB<br> |
| − | 5. convert your data to MySQL | + | 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. | + | 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: | + | On the server:<br> |
| − | - you’ll need an ODBC Driver (MySQL ODBC 5.3 ANSI Driver) | + | - 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 | + | - 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 . | + | - and if you have OPAS Online, you need the same connect string in the uploadxml.cfg .<br><br> |
| − | On every workstation: | + | On every workstation:<br> |
| − | - you’ll need to install the ODBC driver and | + | - you’ll need to install the ODBC driver and <br> |
| − | - configure the ODBC connection like the one the server. | + | - configure the ODBC connection like the one the server.<br><br> |
| − | We support: MySQL >= version 5.6 and Maria DB version 10. | + | We support: MySQL >= version 5.6 and Maria DB version 10.<br><br> |
| − | Having a tool like HeidiSQL or MySQL Workbench can be advantageous. | + | Having a tool like HeidiSQL or MySQL Workbench can be advantageous.<br><br> |
/Woelbitsch | /Woelbitsch | ||
Nuvarande version från 13 november 2017 kl. 14.04
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
