Skip to main content
Question

Views Oracle to SQL Server

  • 29 September 2014
  • 3 replies
  • 22 views

jelle
Contributor
Forum|alt.badge.img+16
Fellow FME'ers, 

 

 

we have migrated data from Oracle Spatial to SQL Server. It works like a charm, without any transformer in between. 

 

 

Does anybody have an idea how we could convert the views, defined in Oracle, to SQL Server using FME?

 

 

 

best regards,

 

Jelle

gio
Contributor
Forum|alt.badge.img+15
  • Contributor
  • September 30, 2014
I usually copy the sql to a txt file and use fme with regexp or stringfunctions to parse the instructions from one sql flavor to another.

jelle
Contributor
Forum|alt.badge.img+16
  • Contributor
  • September 30, 2014
thanks for the tip. It concerns a few hundreds of views, but we will find our way.

gio
Contributor
Forum|alt.badge.img+15
  • Contributor
  • September 30, 2014
...erhmm, thats is a bit too much indeed..

 

 

Maybe Oracle can advise u?

 

 

http://www.oracle.com/technetwork/database/migration/connect-sqlserver-1945229.html

Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings