Question

SQL Server to PostGIS change prefix

  • 13 February 2019
  • 4 replies
  • 3 views
oliver.morris
Rank
Badge +10

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.

4 replies

redgeographics
Rank
Userlevel 5
Badge +25

You could try a StringReplacer on the fme_feature_type attribute.

oliver.morris
Rank
Badge +10
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.
redgeographics
Rank
Userlevel 5
Badge +25
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?

oliver.morris
Rank
Badge +10

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

Thank you

 

 

SQL Server

Postgres

The FME workbench

 

 

Reply


Community Stats

28,729
Posts
109,527
Replies
36,565
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.