pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedDatabase conversion
20+ messages / 14 participants
[nested] [flat]
* Database conversion
@ 2000-04-10 14:22 Steve Murphy <murphy@webgadgets.co.uk>
2000-04-10 14:40 ` Re: Database conversion Mini-Me <c9766@wolf.com>
2000-04-16 20:02 ` Re: Database conversion Max Pyziur <pyz@panix.com>
0 siblings, 2 replies; 20+ messages in thread
From: Steve Murphy @ 2000-04-10 14:22 UTC (permalink / raw)
To: pgsql-admin
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.
^ permalink raw reply [nested|flat] 20+ messages in thread
* Re: Database conversion
2000-04-10 14:22 Database conversion Steve Murphy <murphy@webgadgets.co.uk>
@ 2000-04-10 14:40 ` Mini-Me <c9766@wolf.com>
1 sibling, 0 replies; 20+ messages in thread
From: Mini-Me @ 2000-04-10 14:40 UTC (permalink / raw)
To: Steve Murphy <murphy@webgadgets.co.uk>; +Cc: pgsql-admin
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.
^ permalink raw reply [nested|flat] 20+ messages in thread
* Re: Database conversion
2000-04-10 14:22 Database conversion Steve Murphy <murphy@webgadgets.co.uk>
@ 2000-04-16 20:02 ` Max Pyziur <pyz@panix.com>
2000-04-16 20:40 ` Re: Database conversion brad <brad@kieser.net>
1 sibling, 1 reply; 20+ messages in thread
From: Max Pyziur @ 2000-04-16 20:02 UTC (permalink / raw)
To: pgsql-admin
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/
^ permalink raw reply [nested|flat] 20+ messages in thread
* Re: Database conversion
2000-04-10 14:22 Database conversion Steve Murphy <murphy@webgadgets.co.uk>
2000-04-16 20:02 ` Re: Database conversion Max Pyziur <pyz@panix.com>
@ 2000-04-16 20:40 ` brad <brad@kieser.net>
2000-04-16 22:35 ` Re: Database conversion Chris Carbaugh <cjtech@blazenet.net>
0 siblings, 1 reply; 20+ messages in thread
From: brad @ 2000-04-16 20:40 UTC (permalink / raw)
To: Max Pyziur <pyz@panix.com>; +Cc: pgsql-admin
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/
^ permalink raw reply [nested|flat] 20+ messages in thread
* Re: Database conversion
2000-04-10 14:22 Database conversion Steve Murphy <murphy@webgadgets.co.uk>
2000-04-16 20:02 ` Re: Database conversion Max Pyziur <pyz@panix.com>
2000-04-16 20:40 ` Re: Database conversion brad <brad@kieser.net>
@ 2000-04-16 22:35 ` Chris Carbaugh <cjtech@blazenet.net>
0 siblings, 0 replies; 20+ messages in thread
From: Chris Carbaugh @ 2000-04-16 22:35 UTC (permalink / raw)
To: brad <brad@kieser.net>; +Cc: Max Pyziur <pyz@panix.com>; pgsql-admin
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/
^ permalink raw reply [nested|flat] 20+ messages in thread
* RE: Database conversion
@ 2000-04-11 10:39 Nicolas Huillard <nhuillard@ghs.fr>
0 siblings, 0 replies; 20+ messages in thread
From: Nicolas Huillard @ 2000-04-11 10:39 UTC (permalink / raw)
To: 'Steve Murphy' <murphy@webgadgets.co.uk>; pgsql-admin
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.
^ permalink raw reply [nested|flat] 20+ messages in thread
* Database Conversion
@ 2008-09-04 13:24 Carol Walter <walterc@indiana.edu>
2008-09-04 13:38 ` Re: Database Conversion Achilleas Mantzios <achill@matrix.gatewaynet.com>
2008-09-04 13:41 ` Re: Database Conversion Achilleas Mantzios <achill@matrix.gatewaynet.com>
2008-09-04 15:22 ` Re: Database Conversion Hajek, Nick <Nick.Hajek@Vishay.com>
2008-09-04 17:18 ` Re: Database Conversion H. Hall <hhall1001@reedyriver.com>
2008-09-04 19:42 ` Re: Database Conversion Alan Scott <balanscott@gmail.com>
2008-09-04 20:03 ` Re: Database Conversion Steve Holdoway <steve.holdoway@firetrust.com>
0 siblings, 6 replies; 20+ messages in thread
From: Carol Walter @ 2008-09-04 13:24 UTC (permalink / raw)
To: pgsql-admin
Hello, All,
I have a new faculty member who has a large database that is in
MySQL. We don't support MySQL so the database needs to be ported to
PostgreSQL. Her GA, who know MySQL, says that he has a query that he
will run that will put the data into postgres. I thought that the
data would have to be output to a text file and then copied into
postgres. I don't know MySQL. I've done a conversion from Oracle
and this is how I did it. Is he correct that he can put the data
into a postgres database by running a MySQL query? It doesn't sound
possible to me.
Carol
^ permalink raw reply [nested|flat] 20+ messages in thread
* Re: Database Conversion
2008-09-04 13:24 Database Conversion Carol Walter <walterc@indiana.edu>
@ 2008-09-04 13:38 ` Achilleas Mantzios <achill@matrix.gatewaynet.com>
5 siblings, 0 replies; 20+ messages in thread
From: Achilleas Mantzios @ 2008-09-04 13:38 UTC (permalink / raw)
To: pgsql-admin; +Cc: Carol Walter <walterc@indiana.edu>
Στις Thursday 04 September 2008 16:24:34 ο/η Carol Walter έγραψε:
> Hello, All,
>
> I have a new faculty member who has a large database that is in
> MySQL. We don't support MySQL so the database needs to be ported to
> PostgreSQL. Her GA, who know MySQL, says that he has a query that he
> will run that will put the data into postgres. I thought that the
> data would have to be output to a text file and then copied into
> postgres. I don't know MySQL. I've done a conversion from Oracle
> and this is how I did it. Is he correct that he can put the data
> into a postgres database by running a MySQL query? It doesn't sound
> possible to me.
>
We recently did a conversion from MS Access (i dont know details) to pgsql 8.3.3.
The MS Access-aware guy just declared the correct postgresql ODBC settings,
i adjusted the pgsql backend to accept connections from the MS workstation,
then performed an EXPORT from MS Access to the pgsql datasource
and thats all.
Of course all i got was the exact MS Access tables, which then were useful
to populate my new designed pgsql tables.
One caveat here, most commonly, is the design of the DB.
The lower end you get mysql->sql server->access->COBOL, etc...
the greater chance you need a re-engineering of the schema.
> Carol
>
--
Achilleas Mantzios
^ permalink raw reply [nested|flat] 20+ messages in thread
* Re: Database Conversion
2008-09-04 13:24 Database Conversion Carol Walter <walterc@indiana.edu>
@ 2008-09-04 13:41 ` Achilleas Mantzios <achill@matrix.gatewaynet.com>
2008-09-04 14:33 ` Re: Database Conversion Ben Kim <bkim@tamu.edu>
5 siblings, 1 reply; 20+ messages in thread
From: Achilleas Mantzios @ 2008-09-04 13:41 UTC (permalink / raw)
To: pgsql-admin
Στις Thursday 04 September 2008 16:24:34 ο/η Carol Walter έγραψε:
> Hello, All,
>
> I have a new faculty member who has a large database that is in
> MySQL. We don't support MySQL so the database needs to be ported to
> PostgreSQL. Her GA, who know MySQL, says that he has a query that he
> will run that will put the data into postgres. I thought that the
> data would have to be output to a text file and then copied into
> postgres. I don't know MySQL. I've done a conversion from Oracle
> and this is how I did it. Is he correct that he can put the data
> into a postgres database by running a MySQL query? It doesn't sound
> possible to me.
If his query is like:
SELECT 'INSERT INTO PostgreSqlTable(...) VALUES(''||somevalue...||'')' FROM mysqltable ....
then it is possible
>
> Carol
>
--
Achilleas Mantzios
^ permalink raw reply [nested|flat] 20+ messages in thread
* Re: Database Conversion
2008-09-04 13:24 Database Conversion Carol Walter <walterc@indiana.edu>
2008-09-04 13:41 ` Re: Database Conversion Achilleas Mantzios <achill@matrix.gatewaynet.com>
@ 2008-09-04 14:33 ` Ben Kim <bkim@tamu.edu>
2008-09-04 14:50 ` Re: Database Conversion Carol Walter <walterc@indiana.edu>
0 siblings, 1 reply; 20+ messages in thread
From: Ben Kim @ 2008-09-04 14:33 UTC (permalink / raw)
To: pgsql-admin
> I have a new faculty member who has a large database that is in
> MySQL. We don't support MySQL so the database needs to be ported to
> PostgreSQL. Her GA, who know MySQL, says that he has a query that he
> will run that will put the data into postgres. I thought that the
> data would have to be output to a text file and then copied into
> postgres. I don't know MySQL. I've done a conversion from Oracle
> and this is how I did it. Is he correct that he can put the data
> into a postgres database by running a MySQL query? It doesn't sound
> possible to me.
I don't think mysql has anything that exports data into postgresql. Unless
he is talking about the likes of DTS/SSIS or perl DBI, or other tools. Or
the tables are simple and he thinks he can ingeniously craft queries and
run them through pipes eventually to psql. DDL will be more difficult.
Regards,
Ben
^ permalink raw reply [nested|flat] 20+ messages in thread
* Re: Database Conversion
2008-09-04 13:24 Database Conversion Carol Walter <walterc@indiana.edu>
2008-09-04 13:41 ` Re: Database Conversion Achilleas Mantzios <achill@matrix.gatewaynet.com>
2008-09-04 14:33 ` Re: Database Conversion Ben Kim <bkim@tamu.edu>
@ 2008-09-04 14:50 ` Carol Walter <walterc@indiana.edu>
0 siblings, 0 replies; 20+ messages in thread
From: Carol Walter @ 2008-09-04 14:50 UTC (permalink / raw)
To: Ben Kim <bkim@tamu.edu>; +Cc: pgsql-admin
Well, my database server lives on a Solaris 10 box. I'm running
PosgreSQL 8.2.3. The database that is being converted from MySQL is
currently on a Windows machine. So far it seems that every solution
involves an interim step or two. I think he was alluding to just
running a query.
Carol
On Sep 4, 2008, at 10:33 AM, Ben Kim wrote:
>
>> I have a new faculty member who has a large database that is in
>> MySQL. We don't support MySQL so the database needs to be ported to
>> PostgreSQL. Her GA, who know MySQL, says that he has a query that he
>> will run that will put the data into postgres. I thought that the
>> data would have to be output to a text file and then copied into
>> postgres. I don't know MySQL. I've done a conversion from Oracle
>> and this is how I did it. Is he correct that he can put the data
>> into a postgres database by running a MySQL query? It doesn't sound
>> possible to me.
>
> I don't think mysql has anything that exports data into postgresql.
> Unless he is talking about the likes of DTS/SSIS or perl DBI, or
> other tools. Or the tables are simple and he thinks he can
> ingeniously craft queries and run them through pipes eventually to
> psql. DDL will be more difficult.
>
>
> Regards,
> Ben
>
> --
> Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-admin
^ permalink raw reply [nested|flat] 20+ messages in thread
* Re: Database Conversion
2008-09-04 13:24 Database Conversion Carol Walter <walterc@indiana.edu>
@ 2008-09-04 15:22 ` Hajek, Nick <Nick.Hajek@Vishay.com>
2008-09-04 16:27 ` Re: Database Conversion Scott Marlowe <scott.marlowe@gmail.com>
5 siblings, 1 reply; 20+ messages in thread
From: Hajek, Nick @ 2008-09-04 15:22 UTC (permalink / raw)
To: pgsql-admin
>
> Hello, All,
>
> I have a new faculty member who has a large database that is
> in MySQL. We don't support MySQL so the database needs to be
> ported to PostgreSQL. Her GA, who know MySQL, says that he
> has a query that he will run that will put the data into
> postgres. I thought that the data would have to be output to
> a text file and then copied into postgres. I don't know
> MySQL. I've done a conversion from Oracle and this is how I
> did it. Is he correct that he can put the data into a
> postgres database by running a MySQL query? It doesn't sound
> possible to me.
>
> Carol
>
You could possibly do it in a single operation using MS Access if you
have an ODBC connection to each database. If however the dataset is
large, I wouldn't recommend it. I have a number of MySQL and PostgreSQL
dbs and I either dump sql and then import or use PHP scripts when moving
between the two.
Nick
^ permalink raw reply [nested|flat] 20+ messages in thread
* Re: Database Conversion
2008-09-04 13:24 Database Conversion Carol Walter <walterc@indiana.edu>
2008-09-04 15:22 ` Re: Database Conversion Hajek, Nick <Nick.Hajek@Vishay.com>
@ 2008-09-04 16:27 ` Scott Marlowe <scott.marlowe@gmail.com>
2008-09-04 16:45 ` Re: Database Conversion Carol Walter <walterc@indiana.edu>
0 siblings, 1 reply; 20+ messages in thread
From: Scott Marlowe @ 2008-09-04 16:27 UTC (permalink / raw)
To: Hajek, Nick <Nick.Hajek@vishay.com>; +Cc: pgsql-admin
On Thu, Sep 4, 2008 at 9:22 AM, Hajek, Nick <Nick.Hajek@vishay.com> wrote:
>
>>
>> Hello, All,
>>
>> I have a new faculty member who has a large database that is
>> in MySQL. We don't support MySQL so the database needs to be
>> ported to PostgreSQL. Her GA, who know MySQL, says that he
>> has a query that he will run that will put the data into
>> postgres. I thought that the data would have to be output to
>> a text file and then copied into postgres. I don't know
>> MySQL. I've done a conversion from Oracle and this is how I
>> did it. Is he correct that he can put the data into a
>> postgres database by running a MySQL query? It doesn't sound
>> possible to me.
>>
>> Carol
>>
>
> You could possibly do it in a single operation using MS Access if you
> have an ODBC connection to each database. If however the dataset is
> large, I wouldn't recommend it. I have a number of MySQL and PostgreSQL
> dbs and I either dump sql and then import or use PHP scripts when moving
> between the two.
Also, if you can spare the afternoon to learn it, sed is an awesome
tool for ETL. I've used it for migrating stuff from oracle to pgsql
and mangling input data to work.
^ permalink raw reply [nested|flat] 20+ messages in thread
* Re: Database Conversion
2008-09-04 13:24 Database Conversion Carol Walter <walterc@indiana.edu>
2008-09-04 15:22 ` Re: Database Conversion Hajek, Nick <Nick.Hajek@Vishay.com>
2008-09-04 16:27 ` Re: Database Conversion Scott Marlowe <scott.marlowe@gmail.com>
@ 2008-09-04 16:45 ` Carol Walter <walterc@indiana.edu>
0 siblings, 0 replies; 20+ messages in thread
From: Carol Walter @ 2008-09-04 16:45 UTC (permalink / raw)
To: Scott Marlowe <scott.marlowe@gmail.com>; +Cc: Hajek, Nick <Nick.Hajek@vishay.com>; pgsql-admin
According to the GA, the database has 1,000,000 rows. I hesitate to
pass that along because I don't know what that means. It strikes me
as an odd way to talk about a relational database. Normally, a
relational database has more than one table, so how is a "database"
having a million rows relevant. There are other databases in other
research projects, that have main tables that has well more than a
million records, so I don't know if this is considered large or not.
I thank you, all, for your answers.
Carol
On Sep 4, 2008, at 12:27 PM, Scott Marlowe wrote:
> On Thu, Sep 4, 2008 at 9:22 AM, Hajek, Nick <Nick.Hajek@vishay.com>
> wrote:
>>
>>>
>>> Hello, All,
>>>
>>> I have a new faculty member who has a large database that is
>>> in MySQL. We don't support MySQL so the database needs to be
>>> ported to PostgreSQL. Her GA, who know MySQL, says that he
>>> has a query that he will run that will put the data into
>>> postgres. I thought that the data would have to be output to
>>> a text file and then copied into postgres. I don't know
>>> MySQL. I've done a conversion from Oracle and this is how I
>>> did it. Is he correct that he can put the data into a
>>> postgres database by running a MySQL query? It doesn't sound
>>> possible to me.
>>>
>>> Carol
>>>
>>
>> You could possibly do it in a single operation using MS Access if you
>> have an ODBC connection to each database. If however the dataset is
>> large, I wouldn't recommend it. I have a number of MySQL and
>> PostgreSQL
>> dbs and I either dump sql and then import or use PHP scripts when
>> moving
>> between the two.
>
> Also, if you can spare the afternoon to learn it, sed is an awesome
> tool for ETL. I've used it for migrating stuff from oracle to pgsql
> and mangling input data to work.
>
> --
> Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-admin
^ permalink raw reply [nested|flat] 20+ messages in thread
* Re: Database Conversion
2008-09-04 13:24 Database Conversion Carol Walter <walterc@indiana.edu>
@ 2008-09-04 17:18 ` H. Hall <hhall1001@reedyriver.com>
2008-09-04 17:28 ` Re: Database Conversion Carol Walter <walterc@indiana.edu>
5 siblings, 1 reply; 20+ messages in thread
From: H. Hall @ 2008-09-04 17:18 UTC (permalink / raw)
To: Carol Walter <walterc@indiana.edu>; pgsql-admin
Carol Walter wrote:
> Hello, All,
>
> I have a new faculty member who has a large database that is in
> MySQL. We don't support MySQL so the database needs to be ported to
> PostgreSQL. Her GA, who know MySQL, says that he has a query that he
> will run that will put the data into postgres. I thought that the
> data would have to be output to a text file and then copied into
> postgres. I don't know MySQL. I've done a conversion from Oracle and
> this is how I did it. Is he correct that he can put the data into a
> postgres database by running a MySQL query? It doesn't sound possible
> to me.
>
> Carol
>
Why don't you crate a schema for him and let him try out his idea.
What's the downside?
The upside is that we all may learn something new.
HH
--
H. Hall
ReedyRiver Group LLC
http://www.reedyriver.com
^ permalink raw reply [nested|flat] 20+ messages in thread
* Re: Database Conversion
2008-09-04 13:24 Database Conversion Carol Walter <walterc@indiana.edu>
2008-09-04 17:18 ` Re: Database Conversion H. Hall <hhall1001@reedyriver.com>
@ 2008-09-04 17:28 ` Carol Walter <walterc@indiana.edu>
0 siblings, 0 replies; 20+ messages in thread
From: Carol Walter @ 2008-09-04 17:28 UTC (permalink / raw)
To: H. Hall <hhall1001@reedyriver.com>; +Cc: pgsql-admin
That's a good idea. I think I'll try that.
Carol
On Sep 4, 2008, at 1:18 PM, H. Hall wrote:
> Carol Walter wrote:
>> Hello, All,
>>
>> I have a new faculty member who has a large database that is in
>> MySQL. We don't support MySQL so the database needs to be ported
>> to PostgreSQL. Her GA, who know MySQL, says that he has a query
>> that he will run that will put the data into postgres. I thought
>> that the data would have to be output to a text file and then
>> copied into postgres. I don't know MySQL. I've done a conversion
>> from Oracle and this is how I did it. Is he correct that he can
>> put the data into a postgres database by running a MySQL query?
>> It doesn't sound possible to me.
>>
>> Carol
>>
> Why don't you crate a schema for him and let him try out his idea.
> What's the downside?
>
> The upside is that we all may learn something new.
>
> HH
>
> --
> H. Hall
> ReedyRiver Group LLC
> http://www.reedyriver.com
>
>
> --
> Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-admin
^ permalink raw reply [nested|flat] 20+ messages in thread
* Re: Database Conversion
2008-09-04 13:24 Database Conversion Carol Walter <walterc@indiana.edu>
@ 2008-09-04 19:42 ` Alan Scott <balanscott@gmail.com>
2008-09-04 20:04 ` Re: Database Conversion Carol Walter <walterc@indiana.edu>
5 siblings, 1 reply; 20+ messages in thread
From: Alan Scott @ 2008-09-04 19:42 UTC (permalink / raw)
To: Carol Walter <walterc@indiana.edu>; +Cc: pgsql-admin
What version of Postgres? We have 8.3 and have been using Migration Studio
from Enterprise DB (which is part of the Advanced Server install). Also,
with MySQL 5.0 and above they have some conversion tools that do come with
the install to assist you.
On Thu, Sep 4, 2008 at 9:24 AM, Carol Walter <walterc@indiana.edu> wrote:
> Hello, All,
>
> I have a new faculty member who has a large database that is in MySQL. We
> don't support MySQL so the database needs to be ported to PostgreSQL. Her
> GA, who know MySQL, says that he has a query that he will run that will put
> the data into postgres. I thought that the data would have to be output to
> a text file and then copied into postgres. I don't know MySQL. I've done a
> conversion from Oracle and this is how I did it. Is he correct that he can
> put the data into a postgres database by running a MySQL query? It doesn't
> sound possible to me.
>
> Carol
>
> --
> Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-admin
>
^ permalink raw reply [nested|flat] 20+ messages in thread
* Re: Database Conversion
2008-09-04 13:24 Database Conversion Carol Walter <walterc@indiana.edu>
2008-09-04 19:42 ` Re: Database Conversion Alan Scott <balanscott@gmail.com>
@ 2008-09-04 20:04 ` Carol Walter <walterc@indiana.edu>
2008-09-04 21:15 ` Re: Database Conversion Scott Marlowe <scott.marlowe@gmail.com>
0 siblings, 1 reply; 20+ messages in thread
From: Carol Walter @ 2008-09-04 20:04 UTC (permalink / raw)
To: Alan Scott <balanscott@gmail.com>; +Cc: pgsql-admin
I'm using 8.2.3. I don't know which version of MySQL the faculty
member has her database in.
I really appreciate all the helpful suggestions. This seems like a
very interesting topic.
Carol
On Sep 4, 2008, at 3:42 PM, Alan Scott wrote:
> What version of Postgres? We have 8.3 and have been using Migration
> Studio from Enterprise DB (which is part of the Advanced Server
> install). Also, with MySQL 5.0 and above they have some conversion
> tools that do come with the install to assist you.
>
> On Thu, Sep 4, 2008 at 9:24 AM, Carol Walter <walterc@indiana.edu>
> wrote:
> Hello, All,
>
> I have a new faculty member who has a large database that is in
> MySQL. We don't support MySQL so the database needs to be ported
> to PostgreSQL. Her GA, who know MySQL, says that he has a query
> that he will run that will put the data into postgres. I thought
> that the data would have to be output to a text file and then
> copied into postgres. I don't know MySQL. I've done a conversion
> from Oracle and this is how I did it. Is he correct that he can
> put the data into a postgres database by running a MySQL query? It
> doesn't sound possible to me.
>
> Carol
>
> --
> Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-admin
>
^ permalink raw reply [nested|flat] 20+ messages in thread
* Re: Database Conversion
2008-09-04 13:24 Database Conversion Carol Walter <walterc@indiana.edu>
2008-09-04 19:42 ` Re: Database Conversion Alan Scott <balanscott@gmail.com>
2008-09-04 20:04 ` Re: Database Conversion Carol Walter <walterc@indiana.edu>
@ 2008-09-04 21:15 ` Scott Marlowe <scott.marlowe@gmail.com>
0 siblings, 0 replies; 20+ messages in thread
From: Scott Marlowe @ 2008-09-04 21:15 UTC (permalink / raw)
To: Carol Walter <walterc@indiana.edu>; +Cc: Alan Scott <balanscott@gmail.com>; pgsql-admin
Also you should really look into updating your pg install to 8.2.9.
It takes only seconds / minutes to do. Release notes:
http://www.postgresql.org/docs/8.2/static/release-8-2-4.html
http://www.postgresql.org/docs/8.2/static/release-8-2-5.html
http://www.postgresql.org/docs/8.2/static/release-8-2-6.html
http://www.postgresql.org/docs/8.2/static/release-8-2-7.html
http://www.postgresql.org/docs/8.2/static/release-8-2-8.html
http://www.postgresql.org/docs/8.2/static/release-8-2-9.html
If you skin through there you will see many security, performance, and
reliability fixes that have come out since 8.2.3 was released.
On Thu, Sep 4, 2008 at 2:04 PM, Carol Walter <walterc@indiana.edu> wrote:
> I'm using 8.2.3. I don't know which version of MySQL the faculty member has
^ permalink raw reply [nested|flat] 20+ messages in thread
* Re: Database Conversion
2008-09-04 13:24 Database Conversion Carol Walter <walterc@indiana.edu>
@ 2008-09-04 20:03 ` Steve Holdoway <steve.holdoway@firetrust.com>
5 siblings, 0 replies; 20+ messages in thread
From: Steve Holdoway @ 2008-09-04 20:03 UTC (permalink / raw)
To: pgsql-admin
On Thu, 4 Sep 2008 09:24:34 -0400
Carol Walter <walterc@indiana.edu> wrote:
> Hello, All,
>
> I have a new faculty member who has a large database that is in
> MySQL. We don't support MySQL so the database needs to be ported to
> PostgreSQL. Her GA, who know MySQL, says that he has a query that he
> will run that will put the data into postgres. I thought that the
> data would have to be output to a text file and then copied into
> postgres. I don't know MySQL. I've done a conversion from Oracle
> and this is how I did it. Is he correct that he can put the data
> into a postgres database by running a MySQL query? It doesn't sound
> possible to me.
>
> Carol
>
> --
> Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-admin
I'd use mysqldump to create 2 files: the first being the schema, which I'd tweak to suit ( implementing tablespaces for example ), and then a second dump, which exports the data in a format that is acceptable to postgres.
That way, you end up with what you want in a simple, repeatable manner.
If it's mysql 5 then the stored procedures may need to be converted - I know there are tools out there, but haven't used them and can't comment.
Steve
--
Steve Holdoway <steve.holdoway@firetrust.com>
^ permalink raw reply [nested|flat] 20+ messages in thread
end of thread, other threads:[~2008-09-04 21:15 UTC | newest]
Thread overview: 20+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2000-04-10 14:22 Database conversion Steve Murphy <murphy@webgadgets.co.uk>
2000-04-10 14:40 ` Mini-Me <c9766@wolf.com>
2000-04-16 20:02 ` Max Pyziur <pyz@panix.com>
2000-04-16 20:40 ` brad <brad@kieser.net>
2000-04-16 22:35 ` Chris Carbaugh <cjtech@blazenet.net>
2000-04-11 10:39 RE: Database conversion Nicolas Huillard <nhuillard@ghs.fr>
2008-09-04 13:24 Database Conversion Carol Walter <walterc@indiana.edu>
2008-09-04 13:38 ` Re: Database Conversion Achilleas Mantzios <achill@matrix.gatewaynet.com>
2008-09-04 13:41 ` Re: Database Conversion Achilleas Mantzios <achill@matrix.gatewaynet.com>
2008-09-04 14:33 ` Re: Database Conversion Ben Kim <bkim@tamu.edu>
2008-09-04 14:50 ` Re: Database Conversion Carol Walter <walterc@indiana.edu>
2008-09-04 15:22 ` Re: Database Conversion Hajek, Nick <Nick.Hajek@Vishay.com>
2008-09-04 16:27 ` Re: Database Conversion Scott Marlowe <scott.marlowe@gmail.com>
2008-09-04 16:45 ` Re: Database Conversion Carol Walter <walterc@indiana.edu>
2008-09-04 17:18 ` Re: Database Conversion H. Hall <hhall1001@reedyriver.com>
2008-09-04 17:28 ` Re: Database Conversion Carol Walter <walterc@indiana.edu>
2008-09-04 19:42 ` Re: Database Conversion Alan Scott <balanscott@gmail.com>
2008-09-04 20:04 ` Re: Database Conversion Carol Walter <walterc@indiana.edu>
2008-09-04 21:15 ` Re: Database Conversion Scott Marlowe <scott.marlowe@gmail.com>
2008-09-04 20:03 ` Re: Database Conversion Steve Holdoway <steve.holdoway@firetrust.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox