From: | Dan Armbrust <daniel(dot)armbrust(dot)list(at)gmail(dot)com> |
---|---|
To: | pgsql-general <pgsql-general(at)postgresql(dot)org> |
Subject: | Data conversion tools? |
Date: | 2006-11-15 19:41:41 |
Message-ID: | 455B6D75.9070308@gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
I'm trying to convert a database from either MS Access or MySQL into
Postgres. I have found a couple of tools that will almost do what I
want - but not quite. To make things match up with code that is already
written - I need to have all of the table names and column names
converted to lower case during the conversion process.
I have found a couple of (free or demo) tools that will do it - navicat
has a tools that will convert from MSAccess to Postgres - however, it
doesn't offer a feature to lowercase all of the table names and column
names.
DB Tools Manager Professional will do it as well - but again, no way to
tell it to lowercase things in the process.
PGAdmin II had a tool that would do this - but alas - that part of
PGAdmin was never brought into PGAdmin III. And the last version of
PGAdmin II that I was able to find wouldn't run against my Postgres DB.
Short of installing an older Postgres DB that PGAdmin II will work with
- does anyone else know of a tool that can do what I want?
Is there a script of some sort that I can run that would go through a
set of tables and lowercase everything?
Thanks,
Dan
--
****************************
Daniel Armbrust
Biomedical Informatics
Mayo Clinic Rochester
daniel.armbrust(at)mayo.edu
http://informatics.mayo.edu/
From | Date | Subject | |
---|---|---|---|
Next Message | Ron Johnson | 2006-11-15 19:41:47 | Re: Using SAN Splits to instantly copy a DB |
Previous Message | Ilja Golshtein | 2006-11-15 18:41:52 | Re: Discover temporary INDEX/TABLE name |