July 23rd, 2008, 01:15 PM
|
|
Registered User
|
|
Join Date: Apr 2008
Posts: 6
Time spent in forums: 21 m 40 sec
Reputation Power: 0
|
|
|
Replication - MSSQL Server 2000
An application upgrade required one of the tables being replicated in our transactional replication model to be altered - Column length change.
What I did was:
Code:
Exec dbo.sp_dropsubscription @publication='TowerDB to
KOCSQL03', @article='COD' , @subscriber='KOCSQL03'
Exec dbo.sp_droparticle @publication='TowerDB to KOCSQL03', @article='COD',
@force_invalidate_snapshot=1
Exec dbo.sp_refreshsubscriptions 'TowerDB to KOCSQL03'
--
Once the article was dropped from replication we stopped replication, did the APP upgrade which changed the table, dropped the old table from the subscriber Database and then I did this:
Code:
Exec dbo.sp_addsubscription @publication='TowerDB to KOCSQL03', @article='Tower.COD' , @subscriber='KOCSQL03'
Exec dbo.sp_addarticle @publication='TowerDB to KOCSQL03', @article='tower.COD', @source_table= 'tower.cod' , @destination_table= 'tower.cod' ,
@force_invalidate_snapshot=1
Exec dbo.sp_refreshsubscriptions 'TowerDB to KOCSQL03'
Once the article was added back in, started replication. I expected replication to create the new table on the suscriber but it didn't.
stopped replication again and scripted out the table on the publisher and recreated it on the subscriber.. still won't replicate..
what am I missing here???!!!!????
|
Dev Shed Forums Sponsor:
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
