Timeline for How do you sync changes to the data in your database?
Current License: CC BY-SA 3.0
5 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Aug 18, 2015 at 13:56 | comment | added | cdkMoose | Ours is not a web app, it is thick client with Java based services and Oracle back-end. We have tools for visualizing the workflow state machine, but the data is scripted by the developers. We have a single dev database, each developer does not have their own. | |
| Aug 18, 2015 at 13:20 | comment | added | Christof | What's your dev workflow like? Do you modify your workflow systems in your web app, then copy out the data it creates/modifies/deletes as SQL statements? The risk of missing something when moving over to the db seems high. | |
| Aug 18, 2015 at 12:57 | comment | added | cdkMoose | Many of the apps are workflow systems, where the state machine is defined in the database. Also, look-ups and other reference tables are maintained this way. So, new states or modified reference data are just scripts with inserts, updates or deletes. This is where we are better off than import/export. How would you handle deletes or updates via import/export when multiple devs modifying data in the same table? | |
| Aug 18, 2015 at 12:53 | comment | added | Christof | Thanks for your comment, figured I would these :). Do you actually have tools that you configure in your db or are you just tracking schema changes? | |
| Aug 18, 2015 at 12:46 | history | answered | cdkMoose | CC BY-SA 3.0 |