Hello,
Is possible in FME migrate stored procedure in Oracle no-Spatial to SQL Server?
I saw any links here about run a procedure, but migrate a stored procedure.
Thanks,
Danilo
Solved
Migrate stored procedure
+51- Celebrity
- 2077 replies
Best answer by trentatsafe
Hello @danilo_inovacao ,
As @mark_1spatial suggested with the different languages between Oracle and SQLServer it is not simple. A quick search of the web does yield some possible solutions to migrating a stored procedure from one SQL language to another.
Here is an article that may help get you started:
https://docs.microsoft.com/en-us/sql/ssma/oracle/converting-oracle-schemas-oracletosql
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.
+2I can't see that being possible. Different language specifications between Oracle and SQLServer
PL/SQL T-SQL ?
+6- Safer
- 278 replies
- Best Answer
Hello @danilo_inovacao ,
As @mark_1spatial suggested with the different languages between Oracle and SQLServer it is not simple. A quick search of the web does yield some possible solutions to migrating a stored procedure from one SQL language to another.
Here is an article that may help get you started:
https://docs.microsoft.com/en-us/sql/ssma/oracle/converting-oracle-schemas-oracletosql
+51- Celebrity
- 2077 replies
Hi @mark_1spatial and @trentatsafe thanks yours attention and answer with this case.
So, i hope that do this migration is not suitable?
Thanks,
Danilo
+6- Safer
- 278 replies
Hi @mark_1spatial and @trentatsafe thanks yours attention and answer with this case.
So, i hope that do this migration is not suitable?
Thanks,
Danilo
That is correct, it is not probable to migrate a stored procedure from database to database when their SQL languages have fundamental differences.
As such, it would be best to rebuild the procedure using the new language for the destination database.
+51- Celebrity
- 2077 replies
Hello @danilo_inovacao,
That is correct, it is not probable to migrate a stored procedure from database to database when their SQL languages have fundamental differences.
As such, it would be best to rebuild the procedure using the new language for the destination database.
+51- Celebrity
- 2077 replies
I can't see that being possible. Different language specifications between Oracle and SQLServer
PL/SQL T-SQL ?