nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Geodatabase synchronization between oracle and MS-SQL databases

AbhijeetKulkarni

Hi All,

I am trying to build replication between Oracle and MS-SQL geodatabases but I am unable to do so. Has anyone succeeded in building sync system where source and destination are different DB and different versioning enabled?

Source: Oracle geodatabase (10.4.1)- Traditional versioned

Destination: MS-SQL geodatabase (10.9.1) Branch versioned

Thank You.

Encuentra más publicaciones etiquetadas con

Accepted answers

AbhijeetKulkarni

Since ESRI replication setup is not recommended for multiple complications as mentioned by Vince, we decided to go FME way to extract and insert/update/delete to DEFAULT version using changedetector + AttributeCreator transformers.

Thank you.

All comments

DerekLaw

Hi @AbhijeetKulkarni,

> I am trying to build replication between Oracle and MS-SQL geodatabases ...

FYI, this capability is available in ArcGIS, it's called geodatabase replication.

> Has anyone succeeded in building sync system where source and destination are ... different versioning enabled?

I don't think this is possible. The purpose of replication is to "copy/transfer" content from one geodatabase to another; the same content. What you propose: 'converting' one method of versioning to another is not supported as far as I'm aware.

Hope this helps,

VinceAngelo

I've used a number of mechanisms to push contents from one database to another, but attempting this with different database vendors and such a large release gap and a different versioning model seems to drift into nightmare. For a production system, you really need to limit to no more than one complication (and different versioning models should be scored as two or three complications).

Sorry.

- V

AbhijeetKulkarni

Thank you.

Únete a la Conversación

Los miembros registrados pueden publicar, seguir actualizaciones y más. ¿Nuevo aquí? Regístrate gratis.

Enlaces Rápidos

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.