MS SQL 2K replication/backup - Mailing list pgsql-general

From Jason M. Kuhlman
Subject MS SQL 2K replication/backup
Date
Msg-id 000001c2ed55$bb586250$b211a8c0@HIGHWAYMOBILE
Whole thread Raw
Responses Re: MS SQL 2K replication/backup
List pgsql-general
Hello
We would like to expose some data live to the internet, but some of our
departments are deep in MS SQL.  I know it's possible to replicate SQL to
PostGreSQL. Our data isn't time sensitive so we wouldn't have to have it
replicate live.  What I would like to do is set up a script to
replicate/dump the tables once a night, but I'm not having any luck.

With this scenario this PostGreSQL database could then be a "sort of" backup
also.  Would it be possible, if needed to push these databases back into MS
SQL?  I have been going through the archives for a couple of days, but most
posts seem to be about real time replications.

Any help would be appreciated.

Thanks



pgsql-general by date:

Previous
From: Laurent Perez
Date:
Subject: Re: Listing Users
Next
From: "Greg Sabino Mullane"
Date:
Subject: Mirror site corrections