Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
jpotucek
Constraint Violating Yak Guru
273 Posts |
 Posted - 2008-07-21 : 05:47:31
|
| This weekend we had an application upgrade which changed one replicated table structure. before the upgrade, I used the following to drop the article fom the subscription:Exec dbo.sp_dropsubscription @publication='My Publication', @article='My table' , @subscriber='My Subscriber'Exec dbo.sp_droparticle @publication='My Publication', @article='My Table',@force_invalidate_snapshot=1Exec dbo.sp_refreshsubscriptions 'My Publication'Then I stopped replication (turned off the log reader) After the upgrade ....I scripted out the new table in the publishing database and dropped and recreated it with the new table structure on the subscribing database. I then dropped the primary key on newly created table in the subscribing database, added the article back in to the publication using ENT Manager and turned back on replication. The newly created table data will not replicate? Did I miss some steps???? |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-07-21 : 08:12:16
|
| Did you restart the snapshot agent? |
 |
|
|
|
|
|
table will not replicate