MSSQL to PGSQL table and field names case insensitive

Triskae commented 4 months ago

Hello guys, I'm trying to migrate all data from MSSQL to PGSQL, everything works fine, the data is migrated.

The problem is I don't understand why the case is not respected, for example if I have a table named MailType in source database, I expected pgloader to create the table with same name. Instead, it creates indeed the table, but named "mailtype".

Anyone knows how to get over it ?

Thanks a lot

[X] pgloader --version

   pgloader version "3.6.9"
   compiled with SBCL 2.3.8

[X] did you test a fresh compile from the source tree?

Nop, not tried, but does not seem to be a bug, I'm probably missing some config.

[X] did you search for other similar issues?
[X ] how can I reproduce the bug? simply try to migrate from mssql to pgsql. In source database some tables need to be name with pascal case like "MailType"

LOAD DATABASE
    FROM mssql://username:password@localhost/source-db-name
    INTO pgsql://username:passwordlocalhost/destination-db-name

[X] How the data is different from what you expected, if relevant

I'm expecting to have in the destination database, the table created with the exact same name as in source database, in this case "MailType" instead of "mailtype"

Triskae commented 3 months ago

Up ? As anyone any info about this issue ?

delpine72 commented 1 week ago

hi Triskae, You can use this paremeter quote identifiers in the conf file. I mean: WITH include drop, create tables, no truncate, create indexes, reset sequences, foreign keys, schema only, quote identifiers

dimitri / pgloader

MSSQL to PGSQL table and field names case insensitive #1597