CODEWITHSUNDEEP
sql-serversql-server-2008
savitha
savitha

Reputation: 12669

Synchronizing two Sql Server 2008 databases in same instance

I want to synchronize two databases (DB1 and DB2) present in same instance.

Lets say if i create a table or make any changes to a existing table (e.g. altering the structure) in one database DB1, those should be reflected on the other database DB2

Please help

Savitha

Upvotes: 0

Views: 405

Answers (1)

Rob Farley
Rob Farley

Reputation: 15849

A few options...

Replication Log shipping Triggers

The choice depends on your other needs.

Upvotes: 1

Related Questions