Hi
Kumar,
You'll
need to use PL/pgSQL for your stored procedures.
When I
migrated from Informix I found it was pretty easy - just a syntactic conversion
of the procedures and a few data types to rename. The tricky bit is when you
have used a MS SQL Server concept that PostgreSQL doesn't support. You'll need
to write some new code or at worst redesign your logic to work around the
differences. I don't expect there would be automated tools that could do that
for you.
Regards,
David
|
- [SQL] Migrating Stored Procedures from MS SQL Server Kumar
- David Witham