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
Question
Views Oracle to SQL Server
This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.
+15- Contributor
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.
+23- Contributor
thanks for the tip. It concerns a few hundreds of views, but we will find our way.
+15- Contributor
...erhmm, thats is a bit too much indeed..
Maybe Oracle can advise u?
http://www.oracle.com/technetwork/database/migration/connect-sqlserver-1945229.html
Login to the community
No account yet? Create an account
An FME Account is required to contribute
LoginEnter your E-mail address. We'll send you an e-mail with instructions to reset your password.