Results 1 to 3 of 3
  1. #1
    Join Date
    Nov 2009
    Posts
    15

    Unanswered: Postgre functions need to be converted into SQL Server 2005 functions

    I have a project with postgre sql database. Now whole project need to be hosted at new server. New hosting do not support the Postgre database. I have converted the database into SQL Server 2005 by using a tool. But the user defined functions are not converted. I never worked on Postgre, so I am unable to covert these functions. Can any one help me in converting them?

  2. #2
    Join Date
    Aug 2009
    Location
    Olympia, WA
    Posts
    337
    Good luck. There is no easy way to convert procedures from pg to mssql. They are quite different syntactically. You'll just have to figure out the logic and rewrite in TSQL.

  3. #3
    Join Date
    Aug 2009
    Location
    Olympia, WA
    Posts
    337
    Would be much easier to find new host than to rewrite a bunch of functionality. BTW

Posting Permissions

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