467,200 Members | 1,059 Online
Bytes | Developer Community
Ask Question

Home New Posts Topics Members FAQ

Post your question to a community of 467,200 developers. It's quick & easy.

Converting Stored Process to other DBMS?

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
  • viewed: 1381
Share:
3 Replies
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
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
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.

Similar topics

1 post views Thread by Donald Firesmith | last post: by
1 post views Thread by SLC via DBMonster.com | last post: by
4 posts views Thread by --CELKO-- | last post: by
20 posts views Thread by billmaclean1@gmail.com | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.