By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
437,924 Members | 1,793 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 437,924 IT Pros & Developers. It's quick & easy.

Converting Stored Process to other DBMS?

P: n/a
Hi:

Simple question--is there a tool that convert SQL script written in SQL
Server to the equivalent in another DBMS such as Oracle or DB2?

Thanks!!
blair
Nov 12 '05 #1
Share this Question
Share on Google+
3 Replies


P: n/a
Many of the modelling tools like ERWin, ER/Studio etc. can reverse engineer
from one RDBMS and create scripts for a different target RDBMS. You may find
the following link useful too:

http://vyaskn.tripod.com/oracle_sql_...quivalents.htm

--
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
"Kayda" <bl******@hotmail.com> wrote in message
news:xc********************@comcast.com...
Hi:

Simple question--is there a tool that convert SQL script written in SQL
Server to the equivalent in another DBMS such as Oracle or DB2?

Thanks!!
blair

Nov 12 '05 #2

P: n/a
Blair,

The major products have special migration websites which provide tooling.
If your target it DB2 tools can be found here:
http://www-306.ibm.com/software/data/db2/migration/

Oracle has a similar site.

Cheers
Serge
Nov 12 '05 #3

P: n/a
While there are programs that migrate DDL from database brand to another, I
do not know of program which migrates SQL, or stored procedures, from one
database brand to another.

Brian
http://www.dbpowersuite.com

"Narayana Vyas Kondreddi" <an*******@hotmail.com> wrote in message
news:O5**************@TK2MSFTNGP15.phx.gbl...
Many of the modelling tools like ERWin, ER/Studio etc. can reverse engineer from one RDBMS and create scripts for a different target RDBMS. You may find the following link useful too:

http://vyaskn.tripod.com/oracle_sql_...quivalents.htm

--
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
"Kayda" <bl******@hotmail.com> wrote in message
news:xc********************@comcast.com...
Hi:

Simple question--is there a tool that convert SQL script written in SQL
Server to the equivalent in another DBMS such as Oracle or DB2?

Thanks!!
blair


Nov 12 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.