pgloader/pgloader_data at v3.6.1.1 · Beny13/pgloader · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
load database
     from mssql://{{mssql_user}}:{{mssql_pass}}@{{mssql_server_addr}}/{{source_db}}
     into postgresql://{{psql_user}}:{{psql_pass}}@{{psql_server_addr}}/{{dest_db}}

with preserve index names

excluding table names like 'Audit', 'ObjetServiceHisto', 'ObjetProcessHisto', 'ReportStats', 'LsdStats', 'OrderQueue2' in schema 'dbo'

cast type datetime2 to timestamptz to timestamptz drop default,
     type datetime to timestamptz to timestamptz drop default,
     type char to char,
     type varchar to varchar,
     type int to int,
     type int with extra auto_increment to serial,
     type bigint with extra auto_increment to bigserial

ALTER SCHEMA 'dbo' RENAME TO 'public';