Take the 2-minute tour ×
Geographic Information Systems Stack Exchange is a question and answer site for cartographers, geographers and GIS professionals. It's 100% free, no registration required.

Oracle supports spatial data and so does SQL Server.

What are the things to consider if we have to migrate spatial data from Oracle to SQL Server? Are there any features in Oracle that are not there in SQL Server for supporting spatial data?

We're talking about data maintained by ESRI ArcGIS if that affect answer of the question.

share|improve this question

1 Answer 1

up vote 3 down vote accepted

As long as you have gdb connections to both you will be able to use esri (catalog) tools to move data between.
You will want to double check your CRS for support in both spatial databases.
If you don't use esri tools you will have to register your data in sde.
You simply mention that oracle supports spatial without saying that your data is in oracle spatial.
There are many things to consider if your data type is spatial (SDO) and especially if you are going to mssql-spatial.
It is possible to use both databasees without using "spatial", and unless you are developing applications and or processing huge amounts of data using the sdo functions I would suggest just using the esri binary format and allowing sde to manage the "spatial".
I am sure all of this sounds very confusing unless you already have some understanding of sde.
If not you can read more here...
ESRI Resource Center.

Edit:
When You define a geodatabase in ESRI you have several choices for the rdbms. Oracle, db2, informix, mssql. among others.
SDE creates all the tables and relationships needed to maintain the data with ESRI. There are several choices for the data type for creating tables. ESRI binary is the normal default for most of these rdbms.
Care should be taken when deciding what format to utilize as access from other applications, and interfaces can be affected by this.
ESRI resources should be able to fill in the rest of the gaps.

share|improve this answer
    
I dont have much understand of all of this so thank you for guidance. so SDE saves data in Oracle in some binary format? –  Hasan Khan Apr 11 '11 at 9:15
    
correct in BLOBS (Binary Large Object) –  Mapperz Apr 11 '11 at 14:57

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.