Keeping a Database in sync
I was thinking about developing a little (or maybe not so little, haven't thought it all through yet) app to show you the differences between two databases and allow you to then sync those differences. The reason being, is that we usually have a Development Database and a Production Database. Currently, we just keep track of the changes we make to the development db and once we upload the new version of the app using it, we change the database on production manually to match the development db. It's a pain and easy to screw up or forget something, so I was thinking about writing a DBDiff or something like that.
Before doing that however, I want to make sure there's nothing out there already that rocks and would be ready to go for us for cheap. One of our main problems is that our development server sits internally on our network and our production server sits somewhere else on the internet and we can't run an app that can look at them both simultaneously.
Has anyone seen anything out there that would help with synchronizing databases across networks (i.e. build a schema file, then compare another db to the schema file, etc)? If not, maybe I could write an initial version, then stick it up on GDN Workspaces and have it expanded by myself and others.
Just curious! :)