Subscriptions + Change Views
I have a remote office and want to sync the database with the home office database whenever changes occur. I was down the path of replication but found some information about using subscriptions and change views with Interbase.
What I wasn't able to find was a good tutorial with a step by step guide on how to implement this. Is there a way to automatically update the tables between the databases when changes occur or does the subscription + change view only notify and there were changes.
I would appreciate any help with this
I did not implement what they suggest as I don't have licenses for IBToGo, I used to use IBLite which doesn't come with ChangeView.
What I would implement is something like decide which DB is the reference one: desktop app on a Mac, and then compare your portable devices against that reference.
For dedicated DB my guess is that InterBase should be on a dedicated host that is the reference and then you should work against this one.
Craig Chapmann is the One Guy to be contacted in order to shed some lights. Or Sarina DuPont, she's just so amazingly knowledgeable.
Helpful - can I use the same code, datamodule for both the home office and the remote sites? In other words do I need multiple versions of my app depending on location. thanks
No you still have to do the inside job to actually sync data across devices/desktops.
But Change View makes it easier as it will tell you which one changed and how, without the need to implement that brain yourself in your app, which can be a nightmare.
This video is helping https://www.youtube.com/watch?v=zF81t6GzjNU