philipsoutham/py-mysql2pgsql — Issue #2: Mangle case-sensitive schemas
Author: mmerlone
Created: 2011-11-01 12:53:33+00:00
State: open

Sorry if this is not the right place, couldnt find another... :)
I need to migrate a MySQL database to a PostgreSQL server. On mysql I have all lower-case database, tables and field names, but on Postgres I have CamelCase names. This is the bacula (linux backup tool) database, and thus I cannot change any definition on both servers. When I run py-mysql2pgsql it tells me:

"psycopg2.ProgrammingError: ERROR: relation "BaseFiles" does not exist"

or something like that in pt_BR.
Couldn't your script handle this, or can you suggest a workaround?

Tks, best regards.