Thread: Database conversion
Hi, Does anyone know of any conversion programs that will either convert an MS Access database file to a Postresql database or from a Filemaker Pro database file to a Postresql database for the Red Hat Linux OS? Any help or educated guesses of where to start looking would be extremely welcome. Thanx, Steve.
they i do it those infrequent times i need to is using a program called dbf2sql that will convert from dbf. At 02:22 PM 4/10/00 +0000, Steve Murphy wrote: >Hi, > >Does anyone know of any conversion programs that will either convert an >MS Access database file to a Postresql database or from a Filemaker Pro >database file to a Postresql database for the Red Hat Linux OS? > >Any help or educated guesses of where to start looking would be >extremely welcome. > >Thanx, Steve.
This question has already been asked few times. Please check the mailing-list archive. The names I can provide are : * pgAdmin (for Windows) : this can create tables in a PostgresDB, directly from an Access DB (interactively) * pgUpT (Postgres Upsizing Tool) : an Access database meant to create the SQL code to create the whole Access DB under Postgres(batch mode) Nicolas Huillard G.H.S Directeur Technique Tél : +33 1 43 21 16 66 Fax : +33 1 56 54 02 18 mailto:nhuillard@ghs.fr http://www.ghs.fr -----Message d'origine----- De: Steve Murphy [SMTP:murphy@webgadgets.co.uk] Date: lundi 10 avril 2000 16:23 À: pgsql-admin@postgresql.org Objet: [ADMIN] Database conversion Hi, Does anyone know of any conversion programs that will either convert an MS Access database file to a Postresql database or from a Filemaker Pro database file to a Postresql database for the Red Hat Linux OS? Any help or educated guesses of where to start looking would be extremely welcome. Thanx, Steve.
Steve Murphy wrote: > > Hi, > > Does anyone know of any conversion programs that will either convert an > MS Access database file to a Postresql database or from a Filemaker Pro > database file to a Postresql database for the Red Hat Linux OS? > > Any help or educated guesses of where to start looking would be > extremely welcome. Apologies that this reply is coming possibly a bit late. My experience is essentially limited to Postgres, Informix, and Foxpro, the last in which I haven't done any development in a while. General procedure that I know of is: 1 - dump the schema of one to a file and tweak it so that it conforms to the standards of the target database server 2 - dump the data to a pipe-delimited text file 3 - use the schema from the source database program to create a database in the target database program/server 4 - import the pipe-delimited data. In the case of Informix and Postgres, both have utilities (dbschema and pg_dump with the -s flag, respectively) which allow you to output a databases schema to stdout or a file. I know that with Foxpro 3.0 there was some sort of schema utility included somewhere. Informix has an SQL command called UNLOAD which allows you to dump data to pipe-delimited formats; pg_dump -a dumps the data in postgres; COPY in the postgres monitor gives you a little more control as to the format of data dump. Informix's syntax is a cleaner implementation in this regard, though. Postgres's pg_dump is great, though, for backing up a whole database w/ schema and restoring it. So I only gave you half an answer since I didn't address your MS Access or Filemaker pro issues. I suspect though you can do exports and control the format in some way. > Thanx, Steve. -- Max Pyziur BRAMA - Gateway Ukraine pyz@brama.com http://www.brama.com/
I have had problems with the pg_dump command, though, when the tables have been wide (many columns with long text items in them) and deep (many rows). The pg_dump utility reloads the data from the stdin, using a pipe. This doesn't work too well (i.e. no data gets loaded) for these tables, but is fine for smaller tables. I use linux - nearly every release of kernel 2.0 and 2.2. Max Pyziur wrote: > Steve Murphy wrote: > > > > Hi, > > > > Does anyone know of any conversion programs that will either convert an > > MS Access database file to a Postresql database or from a Filemaker Pro > > database file to a Postresql database for the Red Hat Linux OS? > > > > Any help or educated guesses of where to start looking would be > > extremely welcome. > > Apologies that this reply is coming possibly a bit late. > > My experience is essentially limited to Postgres, Informix, and > Foxpro, the last in which I haven't done any development in a while. > > General procedure that I know of is: > 1 - dump the schema of one to a file and tweak it so that it conforms > to the standards of the target database server > 2 - dump the data to a pipe-delimited text file > 3 - use the schema from the source database program to create a > database in the target database program/server > 4 - import the pipe-delimited data. > > In the case of Informix and Postgres, both have utilities (dbschema > and pg_dump with the -s flag, respectively) which allow you to output > a databases schema to stdout or a file. I know that with Foxpro 3.0 > there was some sort of schema utility included somewhere. Informix > has an SQL command called UNLOAD which allows you to dump data to > pipe-delimited formats; pg_dump -a dumps the data in postgres; COPY in > the postgres monitor gives you a little more control as to the format > of data dump. Informix's syntax is a cleaner implementation in this > regard, though. Postgres's pg_dump is great, though, for backing up a > whole database w/ schema and restoring it. > > So I only gave you half an answer since I didn't address your MS > Access or Filemaker pro issues. I suspect though you can do exports > and control the format in some way. > > > Thanx, Steve. > > -- > Max Pyziur BRAMA - Gateway Ukraine > pyz@brama.com http://www.brama.com/
Check out the ODBC driver on the PG site. Quite simple really. Just load the driver on your Win Box, and create the DSN. Now all you have to do is open Access, and export your tables via ODBC. I have only done this a few times with rather simple databases, but haven't had any troubles. It create both the table definition and the data in the Postgres DB. With Win98 and Access2000 running in a VMWare machine under RedHat6.0, I can't imagine an easier conversion. I actually exported the Access tables via ODBC from one VMWare machine to another VMWare machine running RedHat6.1, PostgreSQL, and PHP. PS: If this message doesn't get to the mailing list, would either Brad or Max forward it there. I think my ISP has a goofy email Alias config. brad wrote: > > I have had problems with the pg_dump command, though, when the tables have > been wide (many columns with long text items in them) and deep (many rows). > > The pg_dump utility reloads the data from the stdin, using a pipe. > This doesn't work too well (i.e. no data gets loaded) for these tables, but > is fine for smaller tables. > > I use linux - nearly every release of kernel 2.0 and 2.2. > > Max Pyziur wrote: > > > Steve Murphy wrote: > > > > > > Hi, > > > > > > Does anyone know of any conversion programs that will either convert an > > > MS Access database file to a Postresql database or from a Filemaker Pro > > > database file to a Postresql database for the Red Hat Linux OS? > > > > > > Any help or educated guesses of where to start looking would be > > > extremely welcome. > > > > Apologies that this reply is coming possibly a bit late. > > > > My experience is essentially limited to Postgres, Informix, and > > Foxpro, the last in which I haven't done any development in a while. > > > > General procedure that I know of is: > > 1 - dump the schema of one to a file and tweak it so that it conforms > > to the standards of the target database server > > 2 - dump the data to a pipe-delimited text file > > 3 - use the schema from the source database program to create a > > database in the target database program/server > > 4 - import the pipe-delimited data. > > > > In the case of Informix and Postgres, both have utilities (dbschema > > and pg_dump with the -s flag, respectively) which allow you to output > > a databases schema to stdout or a file. I know that with Foxpro 3.0 > > there was some sort of schema utility included somewhere. Informix > > has an SQL command called UNLOAD which allows you to dump data to > > pipe-delimited formats; pg_dump -a dumps the data in postgres; COPY in > > the postgres monitor gives you a little more control as to the format > > of data dump. Informix's syntax is a cleaner implementation in this > > regard, though. Postgres's pg_dump is great, though, for backing up a > > whole database w/ schema and restoring it. > > > > So I only gave you half an answer since I didn't address your MS > > Access or Filemaker pro issues. I suspect though you can do exports > > and control the format in some way. > > > > > Thanx, Steve. > > > > -- > > Max Pyziur BRAMA - Gateway Ukraine > > pyz@brama.com http://www.brama.com/