Skip to main content
  • EN
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
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.
thanks for the tip. It concerns a few hundreds of views, but we will find our way.
...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


Community Stats

30,108
Posts
114,295
Replies
37,743
Members
Terms & ConditionsCookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.