Replication - Changes to Server database's impact to local database

[Michael diPilla]

We have a SQLSERVER database that is replicated to many users.
We are currently in an expansion phase where we need to make changes
to the server database. Each time we rollout a new release, we are
deleting the local replicating database and recreating.

Is there any way to automatically transfer the changes from the server
to existing local database without deleting?

[Simon Hayes]

Re: Replication - Changes to Server database's impact to local database

dipillama@nswcc d.navy.mil (Michael diPilla) wrote in message news:<4e67e68b. 0308181234.4c8e 5e98@posting.go ogle.com>...[color=blue]
> We have a SQLSERVER database that is replicated to many users.
> We are currently in an expansion phase where we need to make changes
> to the server database. Each time we rollout a new release, we are
> deleting the local replicating database and recreating.
>
> Is there any way to automatically transfer the changes from the server
> to existing local database without deleting?[/color]

It's not clear what you mean by 'changes' - changes to table
structures can be replicated if you make them through the publication
properties dialogue.

I'd suggest you post this in microsoft.publi c.sqlserver.rep lication,
as you'll probably get a better answer there.

Simon