Skip to main content
  • EN

Hi,

I have many tables in SQL Server under the 'dbo' schema that I would like to replicate to PostGIS under an 'sde' schema. I would like to do this using the dynamic schema functonality. How can I replace the dbo with sde in the fme_feature_type attribute while still bing able to associate the matching schema for the tables using the dynamic writer.

Thank you

Oliver

 

Please forgive the use of schema term - schema in sql server means something different to schema in FME.

You could try a StringReplacer on the fme_feature_type attribute.

thanks @redgeographics I tried that but even through the table name is the correct the schema for the table (i.e. all the attribute fields) doesnt match with the amended fme_feature_type attribute.
thanks @redgeographics I tried that but even through the table name is the correct the schema for the table (i.e. all the attribute fields) doesnt match with the amended fme_feature_type attribute.

So the tables already exist on the PostGIS side?

Sorry no that tables do not exist in postgres. Hope these images help.

Thank you

 

 

SQL Server

Postgres

The FME workbench

 

 

Reply


Community Stats

30,159
Posts
114,480
Replies
37,806
Members
Terms & ConditionsCookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.