Customer Service | Training | Contact Us
You are here: Home > User Forums > arcgis desktop discussion forums > Thread Replies

ArcGIS Desktop Discussion Forums

ArcGIS Desktop - Distributed Geodatabases (Replication, Disconnected Editing) forum

Replication between different RDBMS version...   Jon Pratten Nov 07, 2009
Re: Replication between different RDBMS ver...   Heather McCracken Nov 12, 2009
Report Inappropriate Content • Top • Print • Reply    
Subject Replication between different RDBMS versions 
Author Jon Pratten 
Date Nov 07, 2009 
Message Hi All

Does anyone know whether you can replicate between different versions of Oracle using the replication tools in ArcCatalog?

The parent (Oracle v11) would be used primarily for presentation and integration with other corporate applications. The child (Oracle v10) would be for production and local analysis, replicated over our WAN. We would need to use two way replication so edits can be posted and those few feature classes changed by the applications connected to the parent reflected in the child.

We are in the process of putting together an options paper for a distributed user community and are trying to reuse as much of our existing infrastructure and licenses as possible, hence the question.

Thanks in advance

Jon 
   
Report Inappropriate Content • Top • Print • Reply    
Subject Re: Replication between different RDBMS versions 
Author Heather McCracken 
Date Nov 12, 2009 
Message Hi Jon,

Yes - geodatabase replication works independent of the underlying DBMS. As long as they are both Geodatabases you can create replicas between them. So you can replicate b/w Oracle 11 and Oracle 10, or DB2 and SqlServer... or Informix and Oracle.... and so on.

The only thing to consider is the release of the geodatabase. You can create a replica from a lower release to the same or higher release of the GDB, but you cannot replicate from a higher GDB release to a lower one. So av9.2gdb to av9.3gdb, but not a 9.3gdb to a 9.2gdb.

See the following help topic for more details.
http://webhelp.esri.com/arcgisdesktop/9.3/index.cfm?TopicName=Geodatabase_releases_and_geodatabase_replication


Thanks,
Heather
ESRI Redlands