| From: | "Jason M(dot) Kuhlman" <jkuhlman(at)oglecounty(dot)org> |
|---|---|
| To: | <pgsql-general(at)postgresql(dot)org> |
| Subject: | MS SQL 2K replication/backup |
| Date: | 2003-03-18 13:53:13 |
| Message-ID: | 000001c2ed55$bb586250$b211a8c0@HIGHWAYMOBILE |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Razvan | 2003-03-18 14:06:20 | What is the best way to kill/restart the postmaster? |
| Previous Message | Miguel Carvalho | 2003-03-18 13:46:36 | Trigger issue, bug? on 7.2.1 |