Question

Views Oracle to SQL Server

+11

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.

+11

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?

Sign up