Skip to main content
Question

Migrating data from Oracle to SQL

  • May 12, 2025
  • 1 reply
  • 85 views
fmewithvm
Contributor

I'm migrating spatial data from AutoCAD (hosted in an Oracle database) to a SQL Server(ESRI geodatabase). I want to automatically extract domain values from Oracle lookup tables and populate them as domains in the SQL Server (EGDB) without using ESRI tools (like ArcGIS or ArcPy). Is there a way to automate this process, and what would be the recommended approach?

      1 reply

      j.botterill
      Influencer
      Forum|alt.badge.img+60
      • j.botterillInfluencer
      • Influencer
      • May 13, 2025

      You could use Generate workspace reading all Oracle tables and specifying the writer as SQL Server. However as you clearly ask for creating domains, you’ll instead need the SDE writer format.

      Domains in FME are created on the writer feature type under User Attributes. You select the type = domain for the data type. Here is a getting started article https://support.safe.com/hc/en-us/articles/25407778497421-Working-with-Geodatabase-Domains-Writing-A-Coded-Domain It assumes you already set up a domain on the SDE end… however I thin you can create domains populating the “coded domain” parameter dialogue. 

      There are a few limitations in regard to domain writing. read this section as well !

      You’ll need to use transformers like AttributeValueMapper

        Community Stats

        32,741
        Posts
        124,180
        Replies
        41,240
        Members
        Terms & ConditionsAccessibility statement
        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.