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
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 |