search

nuodb / migration-tools

Migration tools for NuoDB
http://nuodb.github.com/migration-tools/
BSD 3-Clause "New" or "Revised" License
27 stars 10 forks source link

Identifier case when migrating to NuoDB. #7

Closed thebithead closed 11 years ago

thebithead commented 11 years ago

I was using the migration tool to migrate a MySQL database to NuoDB. The source database used a mixture of upper & lower case characters for table name and column name identifiers. After migrating the database to NuoDB, I noticed that the resulting tablename and column names are all in uppercase. I didn't specify --identifier.normalizer parameter. The generated schema.sql didn't quote those identifiers so NuoDB made them uppercase.

-tom

tazija commented 11 years ago

--identifier.quoting=always always generates identifiers in quotes (overrides default setting --identifier.quoting=standard, which quotes only when not allowed characters are met in identifiers)