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
load database
from mssql://USER_NAM@SOME_IP/db
into postgresql:///db
CAST type nvarchar to text drop typemod using remove-null-characters,
type varchar to text drop typemod using remove-null-characters
MATERIALIZE VIEWS view1
including only table names like 'tb1' in schema 'dbo'
set work_mem to '4GB', maintenance_work_mem to '4GB'
before load do $$ drop schema if exists dbo cascade; $$,
$$ CREATE EXTENSION IF NOT EXISTS "uuid-ossp" $$
ALTER schema 'dbo' rename to 'public';
Expected Output:
It should port only view: "view1" but it get all the views from MS SQL.
Debugging:
I can see from query in
```pgloader --debug ms.load```:
that query is missing
"WHERE Clause"
it should filter using " WHERE t.TABLE_NAME IN ('view1')"
but it does not have this Clause
hence it gets all the views...
The text was updated successfully, but these errors were encountered:
harshagarwal001
changed the title
MSSQL Materialize view not working
MSSQL Materialize view is downloading all views instead of filtering & downloading only the ones passed in config.
Dec 20, 2023
pgloader --version
PGLOADER FILE FROM MS SQL TO Postgres
Expected Output:
Debugging:
The text was updated successfully, but these errors were encountered: