Continuously syncing .. we have database in mssql. Ideally we'd like to connect to the mssql databases and pull out the fields/content we required and populate that in a postgres database.
-----Original Message----- From: Adrian Klaver [mailto:[email protected]] Sent: Tuesday, November 10, 2015 1:26 PM To: Mammarelli, Joanne T; [email protected] Subject: Re: [GENERAL] Best tool to pull from mssql On 11/10/2015 10:21 AM, Mammarelli, Joanne T wrote: > Hi .. we're on a hunt to locate either pgloader or the tds_fdw > extension to assist us with pulling data FROM a Microsoft sql server > (we're a windows-based postgres installation). So are we taking about a one time operation or continuously syncing or something in between? > > Is this the proper way to handle the process? > Depends on the answer to the above. -- Adrian Klaver [email protected] -- Sent via pgsql-general mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
