Transform from MSSql to MySql. Mysql.

Från opas
Version från den 13 november 2017 kl. 14.04 av Arne Nilsson (Diskussion | bidrag)
(skillnad) ← Äldre version | Nuvarande version (skillnad) | Nyare version → (skillnad)
Hoppa till: navigering, sök

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

Personliga verktyg
Namnrymder
Varianter
Åtgärder
Navigering
Verktygslåda