0

is it possible to do the Merge Replication in databases that having two different database structures ?

Sonal Muthukumarana
  • 39
  • 6

1 Answers1

1

Do you mean the database has different objects (tables, stored procedures, etc.) - yes definitely. Merge replication is only based on the tables in replication so tables outside that have no impact. You cannot however have differences in the table schema for tables that are replicated. You can have indexes, triggers, etc. different though on those tables (although it may cause replication issues).

Element Zero
  • 1,651
  • 3
  • 13
  • 31