Migrate from DBFCDX TO SQL

[Mario Mansilla]

Hola Rathi :
que diferencias o ventajas / desventajas existen entre sqllite y mysql ?
Tengo que migrar un proyecto de un cliente y no se por cual de ellos decidirme o de lo contrario probar con ADS y continuar con las Dbf .
Saludos .
Mario Mansilla

Hi Rathi:
that differences or advantages / disadvantages between sqllite and mysql?
I have to migrate a project from a client and do not know which of them decide otherwise try and continue with ADS Dbf.
Greetings.
Mario Mansilla

[Rathinagiri]

Please read this...

http://hmgforum.com/viewtopic.php?f=37&t=2948

[Rathinagiri]

If you want to know about the difference between sqlite and mysql,

SQLite is serverless file oriented database.
MySQL is client/server database.

SQLite can handle numerous read operations at a time but will be slow when concurrent write operations are made.
MySQL can handle concurrency both in read and write operations in a better way.

Row level locking is not possible in SQLite officially. You have to write your own procedures.
Row level locking is possible in MySQL officially.

SQLite can be used for testing.
MySQL can be used for live big projects.

[Mario Mansilla]

Muchas gracias Rathi .
El objetivo del cliente es tener la posibilidad de verificar ventas y stock en sucursales , por lo cual son bases que son manipuladas desde varias terminales .
Me parece que la eleccion debe ser sin dudas MySql .
Hare un pequeño proyecto con varias tablas y cualquier duda les consulto , ya que es muy poca mi experincia con bases cliente servidor .
Saludos .
Mario Mansilla

Thank you very much Rathi.
The client's goal is to have the ability to check stock at branch sales and, thus, are bases that are manipulated from several terminals.
I think the choice should be no doubt MySql.
Hare a small project with multiple tables and any doubt consult them, as it is very little my experince with client-server basis.
Greetings.
Mario Mansilla

[bpd2000]

Where to find working example / project related to client-server [very small]

[Rathinagiri]

Even this project can be used as such in MySQL.

[fouednoomen]

Hi Radhi

i convert my sqlite data base to mysql and i replace

* oDB := connect2db( 'Mydbase.db', .f. ) // for sqlite data base

with

oDB := connect2db( 'localhost', 'foued', '210265', 'socomeq' ) // for mysql data base

i have the folowing message : (database could not be connected ! )

[Rathinagiri]

1. Have you changed libs=hmgmysql in project.hbc?
2. Did you check your firewall allowing MySQL at port no. 3306?
3. Is the user 'foued' is 'grant'ed rights to access 'socomeq'?

[fouednoomen]

Good Morning Radhi

1. Have you changed libs=hmgmysql in project.hbc ? =YES
2. Did you check your firewall allowing MySQL at port no. 3306 = firewall not running
3. Is the user 'foued' is 'grant'ed rights to access 'socomeq' ? = YES


regards

Foued

[Rathinagiri]

Can you access the database from any other software like MySQL administrator from the system you are trying to connect?