Maintainence of Replication

Hi Dear...

I have some questions regarding replication in SQL Server 2005.

1. Is it neccessary to have same schema on each side i.e on subsicriber and on publisher?

2. Do replication helps me to replicate the changed schema (of published articals) to the subscribers?

3. If a UDT is defined on publisher and one of its dependent is selected for publication do i need to define the UDT on subscriber manually or it will automatically done for me?

4. pls anyone who can give me the detail known issues and their alternative solutions in regard of maintainence of Replication.

Regards

Mubashar Ahmad

1. Subscriber can have a either the full table, a portion of the table or not at all. You cannot replicate to a totally different schema though.

2. Yes it will replicate ALTER statements.

3. I think you have to do that manaully. However you can set a script to run before the snapshot to create it for you automatically.

4. I dont think anyone can give you that.

Martin

|||

For #3 you have options, see @.schema_option for sp_addarticle.

|||thanks both of you... i ll keep this in mind when i come back to replication.. at the moment i am on long vacations...