Iniciacion sqlite/mysql - Sqlite/mysql initiation

Topic Specific Tutorials and Tips.

Moderator: Rathinagiri

Post Reply
User avatar
jas_sierra
Posts: 18
Joined: Sat Aug 23, 2008 2:13 pm
DBs Used: DBF, Starting In MySQL
Location: Barinitas - Venezuela

Iniciacion sqlite/mysql - Sqlite/mysql initiation

Post by jas_sierra »

Hola a todos, utilizo tablas .dbf y deseo migrar a sqlite o mysql, pueden por favor orientarme que pasos debo dar y cual consideran que es la apropiada, diseño aplicaciones con varios usuarios y estaciones de trabajo, deseo desarrollar una aplicación de punto de venta para pequeños negocios utilizando sqlite o mysql, seguramente en el foro exista información al respecto pero creo que no se buscarla, agradezco sus consejos.

-----------

Hello everyone, I use .dbf tables and I want to migrate to sqlite or mysql, can you please guide me what steps should I take and what do you consider to be appropriate, I design applications with multiple users and workstations, I want to develop a point of sale application for small businesses using sqlite or mysql, surely in the forum there is information about it but I think I do not know, I appreciate your advice.
User avatar
dragancesu
Posts: 920
Joined: Mon Jun 24, 2013 11:53 am
DBs Used: DBF, MySQL, Oracle
Location: Subotica, Serbia

Re: Iniciacion sqlite/mysql - Sqlite/mysql initiation

Post by dragancesu »

First, if you need more users forget the SQLite

MySQL is a good database, you have examples of hmg.3.4.4\ sample\ hfcl\sql\mysql

First you need to import the data, it can be automated, but in the end it can't be 1:1 because MySQL has its own rules
User avatar
jas_sierra
Posts: 18
Joined: Sat Aug 23, 2008 2:13 pm
DBs Used: DBF, Starting In MySQL
Location: Barinitas - Venezuela

Re: Iniciacion sqlite/mysql - Sqlite/mysql initiation

Post by jas_sierra »

Gracias por tu respuesta dragancesu, es una aplicación nueva que haré, asi que no tengo necesidades especiales de importación de datos, por favor indícame cual es la versión de MySQL que debo utilizar con hmg.3.4.4., vi el ejemplo pero no tengo instalado el MySQL
-----------
Thanks for your reply dragancesu, it is a new application that I will make, so I have no special needs for data import, please tell me which version of MySQL should I use with hmg.3.4.4., I saw the example but I don't have installed the MySQL
User avatar
dragancesu
Posts: 920
Joined: Mon Jun 24, 2013 11:53 am
DBs Used: DBF, MySQL, Oracle
Location: Subotica, Serbia

Re: Iniciacion sqlite/mysql - Sqlite/mysql initiation

Post by dragancesu »

for start look

http://hmgforum.com/viewtopic.php?f=5&t ... g&start=10

mysql 5.x verion is ok

HeidiSQL is database manager (like DBU,but more...)
User avatar
jas_sierra
Posts: 18
Joined: Sat Aug 23, 2008 2:13 pm
DBs Used: DBF, Starting In MySQL
Location: Barinitas - Venezuela

Re: Iniciacion sqlite/mysql - Sqlite/mysql initiation

Post by jas_sierra »

Nuevamente muchas gracias dragancesu, fui al hilo que indicaste y me parece muy completa la información que brindas en ellos, en especial para personas que nos acercamos por primera vez a MySQL, que tengas un excelente día, un fuerte abrazo desde Venezuela.

-------------
Again thank you very much dragancesu, I went to the thread you indicated and I find the information you provide in them very complete, especially for people who are approaching MySQL for the first time, have an excellent day, a big hug from Venezuela
Post Reply