| From: | Julien Rouhaud <rjuju123(at)gmail(dot)com> |
|---|---|
| To: | 杨逸存 <1057206466(at)qq(dot)com> |
| Cc: | pgsql-hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: Queries for PostgreSQL DDL convert |
| Date: | 2021-03-11 07:28:13 |
| Message-ID: | 20210311072813.uq3jmasxzyyhxc6y@nol |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On Wed, Mar 10, 2021 at 04:09:49PM +0800, 杨逸存 wrote:
> Dear hacker:
> I am a student from Nanjing University. I have some troubles about DDL statement convertion. I have several MySQL DDL statements from MySQL dump command. Now I wanna convert the statements' grammar so that they can be supported by PostgreSQL. However I have tried the tool - 'SQL Data Definition Language (DDL) Conversion to MySQL, PostgreSQL and MS-SQL' on the wiki website of pgsql but it seems to have some bugs and it cannot convert contents of my .sql files. So is there any tools avaliable for me to accomplish it?
> The mail's attachment is an example I wanna convert. Looking forward to your reply.
Ora2pg (http://ora2pg.darold.net/documentation.html) supports migration from
mysql to postgres. It should be able to take care of the DDL conversion for
you.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Amit Langote | 2021-03-11 07:56:28 | Re: Parallel INSERT (INTO ... SELECT ...) |
| Previous Message | Joel Jacobson | 2021-03-11 07:00:38 | Re: [PATCH] pg_permissions |