Solved

Transfer spatial data from SQL Server 2008 to Oracle 10g

Posted on 2009-05-15
2
507 Views
Last Modified: 2013-12-18
Is it possible to transfer spatial data from SQL Server 2008 to Oracle 10g?
0
Comment
Question by:tomaz108
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 7

Expert Comment

by:meispisces
ID: 24394768
No it is not possible
0
 
LVL 42

Accepted Solution

by:
pcelba earned 50 total points
ID: 24395616
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

Industry Leaders: 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!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

SQL Server engine let you use a Windows account or a SQL Server account to connect to a SQL Server instance. This can be configured immediatly during the SQL Server installation or after in the Server Authentication section in the Server properties …
Shell script to create broker configuration file using current broker Configuration, solely for purpose of backup on Linux. Script may need to be modified depending on OS-installation. Please deploy and verify the script in a test environment.
Video by: Steve
Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function

705 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question