Migrate2Postgres

Migrate2Postgres copied to clipboard

Query to generate PKs

3

Hi, I made a query to generate Pks of tables. The code is below: ``` SELECT DISTINCT KCU.TABLE_SCHEMA ,KCU.TABLE_CATALOG ,KCU.TABLE_NAME ,'ALTER TABLE '+KCU.TABLE_SCHEMA + '.' + KCU.TABLE_NAME +' CONSTRAINT '+...

guilhermebma

When I run migrate.sh ı got following error. Do you guys have any idea? ./migrate.sh: line 5: -Dconnections.mssql.user=readonly: command not found ./migrate.sh: line 6: -Dconnections.mssql.password=secret: command not found Error: Could...

yasinyazici34

Add dont_change option for "table_transform" and "column_transform"

2

I want to have ability to keep casing such as in target db. It is very important thing when you need support several types of db (mssql/postgres/ets) with ORM. I...

AlekseyKapustyanenko

…ransform" This commit add option "dont_change" for parametres "table_transform" and "column_transform". With that option case of table names and column names does not changed via migration.

AlekseyKapustyanenko

If I already had postgres schema with columns of uuid type, dml migration throws error: Error: Insert Failed. org.postgresql.util.PSQLException: Error: column * has uuid type but expression character.

AlekseyKapustyanenko

Other indices except PK?

1

Is it possible to add DDL indexes to each table? I understand that Postgres has very wide possibilities for creating indexes, and in fact all the created indexes probably will...

sgrinko

SCHEMA in uppercase

3

Hi Thank you for this wonderful tool. I have a huge db with camelcase tables - would love to see support for this as well since changing it now is...

ghost

Allow to run command(s) per connection at beginning and end

1

e.g. to disable the TRIGGERS before DML operations run: SET session_replication_role = replica; and then re-enable them at the end with: SET session_replication_role = DEFAULT;

isapir

OutOfMemory when copying a large table

7

hey, I'm trying to use your tool for migrating my project from MSSQL to Postgres, I've been able to migrate all of the tables and the data I had but...

mishael-w