June 27, 2002 at 10:37 pm
1)i want to know if i did some structure changes in source table of a publishing database.
will this get replicate in destination table or i have make changes in destination also.
2)if i create a table or database in source and can i replicate this new table or database to destination without creating these tables
and database in destination server
pl help me?
June 28, 2002 at 4:19 am
On #1, the answer is it depends. In SQL7, no. In SQL2K you can add or delete columns, but not modify. To do this you have to make the changes via the publication tab or using I think sp_repladdcolumn/sp_repldropcolumn. If you just modify the table without using one of those two methods the changes do not get proprogated to the subscriber.
For #2, you can. Whenever you send over a new snapshot the default is to send over the complete object descriptions, data, indexes.
Andy
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply