February 16, 2009 at 9:20 am
Synchronizing two databases in same instance
Hi All
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.
Replication and Database Mirroring can be implemented on multiple instances. But, in my case its Synchronizing Databases on a single instance. Not sure how these are applicable to my issue.
Please Help.
Regards
ItzMe
February 16, 2009 at 10:19 am
Shall we understand you want to replicate DDL but not DML?
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.February 16, 2009 at 12:30 pm
Yes absolutely. Only DDL.
Small Clarification..... Cant we achieve both DML and DDL at the same time.
Regards
Itzme
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply