On 16 May 2008, at 09:01, Shanmugam, Dhandapani wrote:
> Ok..But if I do any changes on slave databases for testing it will
> affect Master server also right...I don't want that to happen..
> After my
> testing on the slave database I need to revert back the databases as
> of
> master
You can't have it both ways - either it stays in sync or it doesn't.
Given that it sounds like you are describing a development
environment, I'd suggest you looking into schema versioning/migration
as available in Ruby on Rails.
Marcus
--
Marcus Bointon
Synchromedia Limited: Creators of http://www.smartmessages.net/
UK resellers of info@hand CRM solutions
marcus@stripped | http://www.synchromedia.co.uk/
Attachment: [application/pkcs7-signature] smime.p7s
