... marea un poco la migración... pero que cambio no es traumatico (conoces un programador que no sea ansioso? :lol: ) P.D.: Kleyber: la descarga de DBF2SQL es incompleta. Alguna otra opcion?
... No tengo todas las respuestas, pero te daré algunas: 1 - http://dev.mysql.com/downloads/ 2 - Despues de tener instalado el MySQL, intenta usar el DBF2SQL (mira http://www.tkinformidia.net, opción DOWNLOADS) y vas a migrar rapidamente tus dbf a MySQL. Hace una prueba y me comentas. 3 - TDolphin ...
... INTO your_table (field1, field2) VALUES ('string1', value1),('string2', value2),('string3', value3);" You can also use a free tool like dbf2sql: http://www.tkinformidia.net/uploads/1/2/0/0/12005968/dbf2sql-3.0.zip
DBF2SQL - Gestor de exportación desde DBF a MySQL / PostgreSQL: http://www.tkinformidia.net/dbf2sql-1.jpg http://www.tkinformidia.net/dbf2sql-2.jpg http://www.tkinformidia.net/dbf2sql-3.jpg ...
... Does anyone know of a program that can take current .dbf files and create a Datebase in SQL and import those existing files as tables ? Search for dbf2sql Regards Tim, You can download at http://www.tkinformidia.net/dbf2sql-3.0.zip. It iport DBFs into MySQL or PostgreSQL databases.
I still have one open question. Does anyone know of a program that can take current .dbf files and create a Datebase in SQL and import those existing files as tables ?
Daniel thanks for the reply. As the table was created by dbf2sql I did not noticed it had a primary key. Now everything works fine., oQuer := oServer:Query( "SELECT NOME,CODI,SQL_ROWID FROM usuarios" )oQuer:GoTop()WHILE !oQuer:eOF()oServer:SqlQuery( ...
I imported a DBF to MySQL with the dbf2sql V2.6 tool. The create statement is: CREATE TABLE `usuarios` ( `nome` varchar(10) DEFAULT NULL, `senh` varchar(10) DEFAULT NULL, `nive` varchar(10) DEFAULT NULL, `digi` ...