dimitri / pgloader

Migrate to PostgreSQL in a single command!
http://pgloader.io
Other
5.35k stars 541 forks source link

pgloader mssql to postgres creates other tables with view filter #1603

Open bheemvennapureddy opened 1 month ago

bheemvennapureddy commented 1 month ago
LOAD DATABASE
     FROM mssql://blah/dev
     INTO postgresql://blah/archive

MATERIALIZE VIEWS
       history AS $$ select * from Receipt where RECEIPT_KEY in ( 1010 ); $$
set work_mem to '32MB', maintenance_work_mem to '512 MB'
alter schema 'dbo' rename to 'arch'
ALTER TABLE NAMES MATCHING 'Receipt' IN SCHEMA 'dbo' RENAME TO 'receipt';

log.txt