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

  • Thank you for your answer Jeff. This was also one of my thought but there are 2 cons:

    - 10gb limits as of version 2012 express and the database should store at least 10 years production

    And

    - the other box runs Linux and they are in love with Postgre

    Do you think that Service Broker is not a good solution? Why? Performance, memory, possible memory leaks?

    Thanks