Link PostgreSQL and SQL server express 2012

0

Good afternoon, I would like to know if it is possible to link my local database (PostgreSQL) with SQLExpress 2012 (I am downloading to install). The same tables that I have in PosgreSQL have them in SQLExpress 2012, if I add a data in SQLExpress 2012 that is also added in PostgreSQL, if I delete a record in SQLExpress that is also deleted in PostgreSQL.

If anyone knows how please help me with information.

Thank you .-

    
asked by andres garcia 20.09.2017 в 21:19
source

1 answer

0

You could do it with link server

Steps

  • Install the PostgreSQL ODBC Driver
  • Create an ODBC Data Source
  • Create a SQL Server Linked Server to PostgreSQL
  • You can find detailed information in

    link

        
    answered by 23.09.2017 в 03:31