January 7, 2003 at 12:27 am
HI All.
Is there any way I can truncate the table which I have published for replication. SQL 7.0 does not allow this. Is there any switch which can be set on an off to truncate the table..
levi
Jesus My Saviour
January 7, 2003 at 3:36 am
You can only delete which will propagate to the subscriber. Otherwise you will need to drop the publication and rebuild it.
January 7, 2003 at 4:45 am
HI antare
Deleting is what we have been doing..but the problem here is the no of records...we will have around 4 million records by the end of the day and it takes a considerable amount of time to delete . On a replicated environment this time is still huge and also the resource utilization. If there were an option of temporarliy disabling and then truncate the required tables and then disable the publisher alone rather than rebuilding the entire publication and subscription would be of great help..
levi
Jesus My Saviour
January 7, 2003 at 5:03 am
Does is make sense to replicate the data then? How about just setting up a linked server to the publisher, creating a view? Or how about putting it in a separate publication, that way you could drop the pub, do the the truncate, put the pub back.
Andy
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply