The forum will be down for maintenance over the weekend of August 18-20, 2017. The forum will be shut down on the evening (EDT) of Friday, August 18. Downtime is unknown but may be up to two days. The forum will be restarted as soon as maintenance is complete.

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: ..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.

asked 02 May '13, 07:41

marchello's gravatar image

accept rate: 14%

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%20Hinsperger's gravatar image

Jason Hinspe...
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
Your answer
toggle preview

Follow this question

By Email:

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



Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text]( "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

Question tags:


question asked: 02 May '13, 07:41

question was seen: 997 times

last updated: 03 May '13, 03:30