# As `root`
yum install freetds freetds-devel tds_fdw96 tds_fdw96-debuginfo
cat <<EOS >> /etc/freetds.conf
[msDB]
        host = remote.host
        port = 1433
        tds version = 7.1
        instance = MSSQLSERVER
EOS
# As `postgres`
CREATE SERVER msdb FOREIGN DATA WRAPPER tds_fdw OPTIONS (servername 'msDB', database 'MSDB', msg_handler 'notice');
CREATE USER MAPPING FOR ms SERVER msdb OPTIONS (username 'user', password 'passwd');
CREATE SCHEMA msdb_remote AUTHORIZATION ms;
IMPORT FOREIGN SCHEMA dbo FROM SERVER msdb INTO msdb_remote;