Re: import a .out file

From: Sean Davis <sdavis2(at)mail(dot)nih(dot)gov>
To: Jonathon Stierman <jonathon(at)vimm(dot)com>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: import a .out file
Date: 2007-09-14 18:53:55
Message-ID: 46EAD8C3.9080102@mail.nih.gov
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Jonathon Stierman wrote:
> Yep, it definitely is a SQL dump -- it looks much the same as .sql files
> that I'm used to dealing with on MYSQL databases.
>
> Do you have any favorite translator tools that I could look in to? The file
> is massive (58 megs worth) and going through it by hand would be quite
> tedious.
>
> I did find this on the MYSQL homepage:
> http://solutions.mysql.com/solutions/partner.php?partner=1881&other=1
> Suggesting some commercial options are available. Have any of you used this
> tool, or other tools, with success?
>
> Thanks Sean, Sibte, & Richard for your help thus far -- it is most
> appreciated!

How many tables? If it is just a few, I would ask for tab-delimited
text files from postgres and then design the database in mysql or mssql
to match the postgres database. SQL::Translator for perl is one option,
but it usually requires some hand-editing, also.

Sean

In response to

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Richard Broersma Jr 2007-09-14 18:59:11 Re: import a .out file
Previous Message Jonathon Stierman 2007-09-14 18:43:33 Re: import a .out file