Results 1 to 2 of 2
  1. #1
    Join Date
    May 2014
    Posts
    1

    Unanswered: How to convert MSSQL stored procedure to PostgreSQL

    Hi Everyone,

    I'm using SQL server 2008 R2 and I've to move all the objects from MSSQL to PostgreSQL. I'm aware of migrating tables and views. But I dont know to convert stored procedure, function and triggers.

    Is there any tools available to migrate those things.?

    Thanks in Advance.

  2. #2
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    I doubt that a tool exists, and I would not trust it if one did. Translating views can be automated, translating procedural code is possible but several thousand times harder.

    -PatP
    In theory, theory and practice are identical. In practice, theory and practice are unrelated.

Posting Permissions

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