Posted by Martijn Tonies on 09/14/05 20:50

> I am an SQL server newbie. Our company has a massive application
> written in PL/SQL. I need to port parts of it to SQL Server.
>
> - Which SQL server version should I choose, to have a reasonable chance
> of porting?

I'd say, try the 2005 beta.

> - Could you recommend any best practices, tools? I use Toad for SQL
> development on Oracle, I am looking for something similar for SQL
> server.

Database Workbench ( www.upscene.com ) can do both Oracle and
MS SQL Server. SQL Server 2005 support is in the making.

As for "simply porting" your application -- that will be hard, believe
me. Both are quite different. For example, MS SQL Server only has
"after action" triggers.

--
With regards,

Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, Oracle & MS SQL
Server
Upscene Productions
http://www.upscene.com
Database development questions? Check the forum!
http://www.databasedevelopmentforum.com

[Back to original message]