Perform only schema change replication and avoid data repl..

FAQ

Profile

Perform only schema change replication and avoid data repl..

Database Forums (Home) -> Replication

Next: Can't start DAS server after relocating Ingres

Author

Message

Manish

External

Since: Nov 14, 2007
Posts: 4

(Msg. 1) Posted: Mon Mar 01, 2010 11:34 pm Post subject: Perform only schema change replication and avoid data replication. Archived from groups: microsoft>public>sqlserver>replication (more info?)

Hello! I am having typical scenario in sql merge replication. I need to synchronize table with data and schema changes. But for one column in the table should not be replicated. Schema of the column should be replicated but data should not be. The column allows null so how to stop data replication for selected columns. Schema changes should be propagated. For other columns the data and schema changes should be replicated. >> Stay informed about: Perform only schema change replication and avoid data repl..

Display posts from previous:

Related Topics:

Schema changes screw up transactional replication - Hi We have two servers with SQL Server 2005, version 9.0.3042 on both. There is a transactional replication between them but when we make schema changes on the publisher something goes wrong. We get this error message Subquery returned more than 1..

SQL2005 Merge - extremely slow on schema change - I have a very strange issue with merge replication. I recently published some changes to triggers and stored procedures. The script took less than a minute to run on the master database. On a good link (gigabit LAN) the changes replicated in about 5..

Merge replication deletes non-articles' data - Good day to all. I need help here. I am using SQL server 2000 with lastest service pack. I intend to change the static row filtering clause to a new one as following 3 steps described in Microsoft Official site for an existing merge replication. The..

How to activate "Initialize the schema and data by Snapsho.. - Hi All, Since I have the full set of data in Subscriber, I selected "The subscriber already has the schema and data" when setting the transaction replication. However, I find that only the data change in the Publisher will be replicated to Su...

Replication-Replication Distribution Subsystem: agent (nul.. - After migrate SQL 2000 replication to SQL 2005, by script and have maked some changes, like drop some publications and have added many articles in one, this message has appered so often: Replication-Replication Distribution Subsystem: agent (null)..

	Database Forums (Home) -> Replication	All times are: Pacific Time (US & Canada)
Page 1 of 1

You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum