Home Forums SQL Server 2012 SQL Server 2012 - T-SQL Sending data from MS SQL Server do PostgreSQL server using CLR triggers RE: Sending data from MS SQL Server do PostgreSQL server using CLR triggers

  • Hello Mr Eiriksson,

    I plaied around a little with the PERMISSION_SET and the UNSAFE setting gets the best result, i.e. what you can read in my previous post (the other PERMISSION_SETs just required the UNSAFE PERMISSION_SET, even if I read it is a little dangerous).

    Do you know of any other way to send data from SQL Server to another type of database. I am also considering Service Broker and an external .NET application that read messages and write autonomously into the other server.

    Regards