Skip to main content
Question

SQL Server to PostGIS change prefix

  • February 13, 2019
  • 4 replies
  • 10 views
oliver.morris
Contributor
Forum|alt.badge.img+12

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
Celebrity
Forum|alt.badge.img+50

You could try a StringReplacer on the fme_feature_type attribute.

oliver.morris
Contributor
Forum|alt.badge.img+12
  • oliver.morrisContributor
  • Author
  • Contributor
  • February 13, 2019
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
Celebrity
Forum|alt.badge.img+50
oliver.morris wrote:
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
Contributor
Forum|alt.badge.img+12
  • oliver.morrisContributor
  • Author
  • Contributor
  • February 13, 2019

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

Thank you

 

 

SQL Server

Postgres

The FME workbench

 

 

Reply


Helpful Members This Week

Community Stats

31,408
Posts
119,108
Replies
39,030
Members

Latest FME

Terms & ConditionsCookie settings

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie 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.