Solved

Migrate stored procedure

  • 25 August 2017
  • 6 replies
  • 0 views
danilo_fme
Rank
Userlevel 4
Badge +30

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

icon

Best answer by trentatsafe 25 August 2017, 18:59

View original

6 replies

M
Badge +2

 

I can't see that being possible. Different language specifications between Oracle and SQLServer

 

PL/SQL T-SQL ?

 

T
Rank
Badge +6

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

 

 

danilo_fme
Rank
Userlevel 4
Badge +30

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

T
Rank
Badge +6

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

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.

 

danilo_fme
Rank
Userlevel 4
Badge +30
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.

 

Perfect. Thanks!

 

 

danilo_fme
Rank
Userlevel 4
Badge +30

 

I can't see that being possible. Different language specifications between Oracle and SQLServer

 

PL/SQL T-SQL ?

 

Thanks @mark_1spatial

 

Reply


Community Stats

28,716
Posts
109,494
Replies
36,561
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.