will the source table structure get replicate in d

  • 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?

  • 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

    http://www.sqlservercentral.com/columnists/awarren/

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply