scenariors on streams
I am working on streams replication and i need help in setting up streams in different scenarios as mentioned below.
1) Complete Schema replication ( Full consistency)
2) Schema Replication + Drop Some tables on the target side
3) Schema Replication + Add new tables on the target side
4) Schema Replication + Add new columns on the target side
5) Schema Replication + Add new indexes on the target side
6) Schema Replication + Drop existing columns on the target side
7) Schema Replication + Drop existing indexes on the target side
8) Schema Replication + Modify /drop procedures/other objects on the target side
9) Schema Replication + LOB Data replication
10) Schema Replication + Selective columns on selective tables on source/target side