bidirectional synchronisation of databases
Posted on 2009-07-15
This is my database set up:
I have a development machine on which i may change the database structure and add some data which is normally constant data (e.g. tables that hold data that is typically used to populate drop down lists and the link such as Title [mr, mrs, miss]). It also has some test data that i play around with. I have a production machine that uses the database structure and constant data from the development machine and gets its own 'real data' from people who use my application.
I would like to be able to synchronise the database structure and constant data from the development machine to the production machine but NOT copy across my 'play' data. Sometimes i might want to copy some 'real' data from the production machine to the development database.
What technology do i need to achieve this? I didn't think replication was suitable because i don't really have a master slave relationship. I have seen something called syncman i was going to look into.
Any advice appreciated