Thread: MS SQL 2K replication/backup

MS SQL 2K replication/backup

From
"Jason M. Kuhlman"
Date:
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



Re: MS SQL 2K replication/backup

From
Dennis Gearon
Date:
That does seem to be a problem with Postgres, shutting down the server
to do major 'fills' / 'updates'.

Jason M. Kuhlman wrote:
> 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
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
>     (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
>