Re: Testing / debuging data import
| От | Shoaib Mir |
|---|---|
| Тема | Re: Testing / debuging data import |
| Дата | |
| Msg-id | bf54be870610041250w77c66afw36b78b21128a27a8@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: Testing / debuging data import (Michael Fuhr <mike@fuhr.org>) |
| Список | pgsql-novice |
There is this open source tool "mysql2psql" which is bascially a Perl script that can take as an input MySQL dump file and covnert that to a PostgreSQL specific dump file so that you can restore the dump file easily in PostgreSQL.
You can find the tool at --> http://gborg.postgresql.org/project/mysql2psql/projdisplay.php
Thanks,
----
Shoaib Mir
EnterpriseDB (www.enterprisedb.com)
You can find the tool at --> http://gborg.postgresql.org/project/mysql2psql/projdisplay.php
Thanks,
----
Shoaib Mir
EnterpriseDB (www.enterprisedb.com)
On 10/4/06, Michael Fuhr <mike@fuhr.org > wrote:
On Wed, Oct 04, 2006 at 09:03:50AM +0200, Brendon Gleeson wrote:
> Basically what I want to do is simulate a data import (from a file with
> full insert statements and no table creation), I want the offending
> record/line to be printed to stdout with a verbose / helpful error.
This doesn't quite meet your requirements, but have you looked at
pgloader?
http://pgfoundry.org/projects/pgloader/
--
Michael Fuhr
---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster
В списке pgsql-novice по дате отправления: