• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 521
  • Last Modified:

Transfer spatial data from SQL Server 2008 to Oracle 10g

Is it possible to transfer spatial data from SQL Server 2008 to Oracle 10g?
0
tomaz108
Asked:
tomaz108
1 Solution
 
meispiscesCommented:
No it is not possible
0
 
pcelbaCommented:
It is possible but in text format only. Let suppose you have table containing GeogCol1 column with spatial data. The GeogCol2 column is computed varchar(max) and its value is calcualted by STAsText() function from geography data:

CREATE TABLE [dbo].[SpatialTable](
      [id] [int] IDENTITY(1,1) NOT NULL,
      [GeogCol1] [geography] NULL,
      [GeogCol2]  AS ([GeogCol1].[STAsText]())
) ON [PRIMARY]

So, you may transfer spatial data as varchar texts. Their processing in Oracle is another question, of course.
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now