From: | Chris Smith <chris(at)interspire(dot)com> |
---|---|
To: | Vaughan Bezuidenhout <vaughan(at)ibsoft(dot)co(dot)za> |
Cc: | sydpug(at)postgresql(dot)org |
Subject: | Re: Question. |
Date: | 2006-08-23 00:37:22 |
Message-ID: | 44EBA342.1000703@interspire.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | sydpug |
Vaughan Bezuidenhout wrote:
> Hi There,
>
> I develop software and have decided to try postgresql as a db. Can
> anyone please advise me om how to read the postgresql schema with vb6. I
> need to convert existing tables in MySQL to Postgresql. I need to
> develop this migration tool myself to use elsewhere, so I need to read
> the MySSQL schema(which I can do) and port the structure to Postgresql.
> Thereafter I will convert each field of each record.
You could look at how phppgadmin (http://phppgadmin.sf.net) does it.
You could also look at using a script to do the conversion for you:
http://pgfoundry.org/projects/my2postgres/
and this may also help out in the short term:
http://pgfoundry.org/projects/mysqlcompat/
You'd probably get better responses on one of the postgresql lists:
http://www.postgresql.org/community/lists/ (probably -general)
--
Best Regards,
Chris Smith
PHP Product Manager
Interspire - The World's Best Selling Webware
http://www.interspire.com
From | Date | Subject | |
---|---|---|---|
Next Message | Gavin Sherry | 2006-09-05 01:32:48 | Today's SydPUG meeting cancelled |
Previous Message | Gavin Sherry | 2006-08-22 23:07:57 | Re: Question. |