[rogeriopereira]

Hi,

I want to migrate from MS SQL Server to PostgreSQL, and my final decision depends upon the complexity of stored procedures migration to PostgreSQL.

Nowadays I have lots of stored procedures (T-SQL) that must be translated to PL/pgSQL, so the migration process to PostgreSQL can be accomplished.

Considering this scenario, I have a list of T-SQL language features I use in my app, and I am willing to know whether there are any pgSQL language equivalents, or whether I should consider pgSQL language alternatives to get the same SQL Server functionalities.

I hope someone can help me in this topic.

1) Is it possible to return recordset / subqueries from a PostgreSQL stored procedure?

2) Can I use as many input and output type arguments in PostgreSQL stored procedures as I want?

3) Does it support IF...BEGIN...ELSE.... END flow structures?

4) Does it support WHILE...BEGIN... END flow structures?

5) SQL Server has such global variables as @@rowcount, @@error and @@fetch_status. Does pgSQL have the same functionalities?

6) Does it support global cursors (scope independent cursors)?

7) SQL Server supports SQL declarations like select @var = txVar from table. What about PostgreSQL?

8) Does PostgreSQL support stored procs/functions encryption?

Thanks in advance,

Rogerio

[eperich]

I cannot anser this questions exactly

try the usenet/mailing list
pgsql-sql there are experts on this. also one of those who have migrated from MSSQL to postgres

[karim2k]

have no idea about T-SQL , but looking forwrad to the Pl/SQL , I don't think That the migration would be diffucult, U can for example extrcat the stored procedures , and make a translator, or try to migrate with ADO .Net I think that suppports such operations !

Good Luck !

[rogeriopereira]

Hi,

Thanks for your reply.

But can you explain how to use ADO.Net to help me in this migration process?

I am not familiar with ADO.Net and would like more details on how this could be accomplished using it.

Thanks,

Rogerio

[karim2k]

I'm right now very busy , but try to http://www.gotdotnet.com get .Net framwork and try to do it ! I think that ther's also a migration kit to oracle it could be helpfull !