SQL 6.5 Replication

[Chris Ferraro]

Hi, would anyone know of any products that will allow real-time replicaton between SQL servers. The purpose of the replication is to provide fault tolerance and redundancy. Ideally, the product would also be able to replicate static content as well. Any suggestions would be welcomed.

Thanks, Chris :>

[Peter Cwik]

No extra product is needed, SQLServer will do it.

On 9/21/98 11:16:48 AM, Chris Ferraro wrote:
> Hi, would anyone know of any products that will allow real-time replicaton
> between SQL servers. The purpose of the replication is to provide fault
> tolerance and redundancy. Ideally, the product would also be able to
> replicate static content as well. Any suggestions would be welcomed.
>

Thanks, Chris :>

[Don Romano]

I view `real-time replication` as an oxymoron. Replication is not a great way to provide complete real-time fault tolerance. It can be close but it will always be a little behind as data is copied.

SQL Server has replication but what you want to really look at is some sort of shadowing/mirroring either via SQL Server, the OS or via hardware. You might want to look at clusters or software like Octopus.

Don

On 9/21/98 11:16:48 AM, Chris Ferraro wrote:
> Hi, would anyone know of any products that will allow real-time replicaton
> between SQL servers. The purpose of the replication is to provide fault
> tolerance and redundancy. Ideally, the product would also be able to
> replicate static content as well. Any suggestions would be welcomed.
>

Thanks, Chris :>