Replication Advice

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Andrew Neillans - 29 Jan 2007 14:06 GMT

Hi all,

I am in need of some replication advice...

We have the following scenario:

Publisher running SQL Server 2005 with SP1
Multiple subscribers (at the minute, 10, but there will eventually be
around 30), running a mixture of SQL Server 2005 Express and SQL
Server 2005.

Now, I am fairly inexperienced with replication via the web service
(IIS), and have started looking at this particular project at work
using replication, and noticed something that does not seem right.

Whenever any schema changes are committed, we are forced to regenerate
the complete snapshot, and as such, the subscribers are forced to
download and re-initialise their snapshot.
Surely this is incorrect? Is there any way of configuring incremental
snapshot changes?

The big problem we have is that there database is around 200Mb, and we
have users who pay per MB...

Sorry for lack of information, as I say, I'm fairly new to Server to
Client replication - I normally only configure Server to Server!

Regards,

Andy Neillans

Reply to this Message

confused - 29 Jan 2007 15:19 GMT

I too would be interested in this reply because my databasr is 1.6gb and to
generate a snapshot every time a schema changes is a real pain in the
butt.....

Is it possible to create a snapshot on the publisher and then 'part' copy
over the new schema and tables to the subscriber (in my case).

Thanks

> Hi all,
>
[quoted text clipped - 26 lines]
>
> Andy Neillans

Reply to this Message