How to migrate Oracle SDO (spatial) into SQLA

Hi, we have a GIS application here, intending to be migrated to SQLA 12/16. Its using Oracle SDO types pretty much, which are some special spatial types for geometry, under MDSYS schema. Dont know much about it, but as per: http://en.wikipedia.org/wiki/Oracle_Spatial_and_Graph ..its not only single datatype as we all know with SQLA, but it also bundles lots of other stuff, like special geo indexing, separate engine, some converters etc..

I was trying with PowerDesigner, it converts oracles spatial datatypes into char(10) types, but I believe here its not so easy, though I have zero experiences with spatial data on both ORA and SQLA.

Is it possible to get those SDO data into SQLA, and/or how does it work with Mobilink ?

Many thanks in advance.

spatial

asked 02 May '13, 07:41

marchello
370●2●6●14
accept rate: 14%

flat view

One Answer:

active answers oldest answers newest answers popular answers

The Oracle spatial data can be unloaded into a common format that can be loaded into SQL Anywhere spatial columns. The format is either "well known text" or "well known binary". I think the oracle function is called something like sdo_util.to_wktgeometry().
In SQL Anywhere, you would then use the ST_GeomFromText() method to load the data into a spatial column.

For example, if you set up a proxy connection to Oracle from SA, you could do something like this
(note that this is pseudocode):
create variable xfer long varchar;
select sdo_util.to_wktgeometry(geometry_column) into xfer from Oracle_geometry_table;
Insert into SA_geometry_table( geometry_column) values( ST_Geometry::ST_GeomFromText( xfer, srid ) );

The srid value is the spatial reference system being used for the data, which you can look up in the Oracle database definition.

permanent link

answered 02 May '13, 10:32

Jason Hinspe...
2.7k●6●34●47
accept rate: 35%

Many thanks Jason, will discuss it our team, in case we would need some more info, will kindly let you know here. cheers

(03 May '13, 03:05) marchello

flat view

Your answer

toggle preview

community wiki:

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

*italic* or _italic_
**bold** or __bold__
link:[text](http://url.com/ "title")
image?![alt text](/path/img.jpg "title")
numbered list: 1. Foo 2. Bar
to add a line break simply add two spaces to where you would like the new line to be.
basic HTML tags are also supported

learn more about Markdown

Question tags:

spatial ×24

question asked: 02 May '13, 07:41

question was seen: 2,329 times

last updated: 03 May '13, 03:30

SAP SQL Anywhere

How to migrate Oracle SDO (spatial) into SQLA

Follow this question

Related questions