SQL SP to connect to PostGreSQL RRS feed

  • Question

  • Hi,

    I want to create to Store Proc in MS SQL and save it on MS SQL Server 2005 on my machine, but the SP should connect to a table in postgresql DB located on a different machine. I have access to the machine and to the postgre daba nd the table and its contents.

    I want to be able to run the SP and pull data from Postgre directly and save it to my local table in my local DB.

    Is this possible? If yes, how? If there are any articles, could you please direct me to it.
    Thank you,
    Tuesday, September 1, 2009 5:19 PM