Re: import a .out file
От | Sean Davis |
---|---|
Тема | Re: import a .out file |
Дата | |
Msg-id | 46EAD8C3.9080102@mail.nih.gov обсуждение исходный текст |
Ответ на | Re: import a .out file ("Jonathon Stierman" <jonathon@vimm.com>) |
Ответы |
Re: import a .out file
|
Список | 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
В списке pgsql-novice по дате отправления: