Posted by DA Morgan on 09/14/05 18:27

prunoki wrote:
> Hello,
>
> 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?
>
> - Could you recommend any best practices, tools? I use Toad for SQL
> development on Oracle, I am looking for something similar for SQL
> server.
>
> Regards,
>
> Hegyvari Krisztian

Depending on what you mean by the word "port" I would suggest you not
do it.

If your Oracle application uses sequences ... SQL Server doesn't have
them. If your Oracle application uses the full range of triggers ...
SQL Server doesn't have them. If your Oracle application uses many
different table and index types ... SQL Server doesn't have them. If
your application assumes the Oracle transaction model, locking model,
and read-write consistency ... SQL Server doesn't have them.

It would be far better to rewrite the application based on the Oracle
version to take advantage of optimizing SQL Server's capabilities.
People that try to port, either way, almost always make big expensive
messes.

An application built in an environment where reads don't block writes
and writes don't block reads will fare very poorly in one that doesn't
have the same architecture.
--
Daniel A. Morgan
http://www.psoug.org
damorgan@x.washington.edu
(replace x with u to respond)

[Back to original message]