Results 1 to 5 of 5
  1. #1
    Join Date
    Jul 2003
    Location
    São Paulo, Brazil
    Posts
    4

    Post Unanswered: MS SQL Server stored procs migration

    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

  2. #2
    Join Date
    Sep 2001
    Location
    Vienna
    Posts
    400

    sored procedures

    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
    http://www.postgresql.org
    --Postgresql is the only kind of thing--

  3. #3
    Join Date
    Apr 2003
    Location
    Tunisia
    Posts
    192

    Thumbs up opps

    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 !
    Open up
    Take a look to my Blog http://www.rundom.com/karim2k

  4. #4
    Join Date
    Jul 2003
    Location
    São Paulo, Brazil
    Posts
    4
    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

  5. #5
    Join Date
    Apr 2003
    Location
    Tunisia
    Posts
    192

    Smile Ok

    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 !
    Open up
    Take a look to my Blog http://www.rundom.com/karim2k

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •