Quote:> We are running SQL Server 7.0 by the way
Making changes to the schema becomes a royal PITA.
This is one area that SQL 2000 is much better at.
We routinely do this. Keep in mind, replication is NOT instaneous. It can
be delayed by a noticable amount.
So you wouldn't want say clients reading financial data reading the
Other than that, I like it.
> > I have been told that we intend to use replication to maintain a copy of
> > entire database.
> > This is being done partially as a backup but also to provide a copy of
> > data on which reports
> > and ad hoc querys created by users can be run.
> > Our live database is reasonablely well used.
> > What are the implications of replicating the entire database?
> > Regards
> > Ian Wyld