Re: Quick question MySQL --> PgSQL

On 3/6/01, 5:26:18 PM, Josh Berkus <josh(at)agliodbs(dot)com> wrote regarding [SQL]
Quick question MySQL --> PgSQL:

> Folks,

> Just a quick question ... I need to do a regular transfer (daily +
on
> demand) of data from a MySQL database to a PostgreSQL database and back
> again. Can anybody steer me towards a good script for this, or do I
> have to write my own in PHP?

Don't think you'll find much off the shelf - this sort of thing tends to
be specific to each person and each project. It's just a matter of
SELECTing from MySQL and INSERTing into PostgreSQL in a loop. Be careful
with things like times and dates and if you are doing it in PHP make sure
you've thought about error recovery. I'd recommend copying into an import
table then when it's confirmed that's worked do an internal copy in PG.

Remember if it's run from a browser the user can just break the
connection. Consider running it from a cron-job with lynx or wget (or
write the thing in perl).

> Sorry to bother everyone with something that isn't strictly a SQL
> question, but I'm not sure where else to ask.

> -Josh Berkus

> P.S. If somebody wants consulting $$$ for the above, it may be
> available.

Sadly I charge in £££ and it doesn't sound like a large enough job to
make it worth mucking around with conversions.

- Richard Huxton