You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
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
pgloader --version
pgloader version "3.6.9"
compiled with SBCL 2.3.8
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.
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
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"
The text was updated successfully, but these errors were encountered:
Triskae
changed the title
MSSQL to PGSQL case no respected
MSSQL to PGSQL table and field names case insensitive
Jul 22, 2024
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
pgloader --version
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.
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"
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"
The text was updated successfully, but these errors were encountered: