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
+45- Evangelist
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
+2I can't see that being possible. Different language specifications between Oracle and SQLServer
PL/SQL T-SQL ?
+6- Safer
- 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
+45- Evangelist
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
danilo_fme wrote:
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.
+45- Evangelist
trentatsafe wrote:
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.
+45- Evangelist
mark_f wrote:
I can't see that being possible. Different language specifications between Oracle and SQLServer
PL/SQL T-SQL ?
Reply
Rich Text Editor, editor1
Editor toolbars
Press ALT 0 for help
Helpful Members This Week
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.