Timeline for Handling database schema changes when pushing new versions
Current License: CC BY-SA 3.0
12 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Aug 3, 2017 at 17:48 | comment | added | Itay Moav -Malimovka | We faced the same issue, we wrote a tool. Each upgrade is a file with a numeric identifier (run files from low number to higher number), It checks each file against a test DB before releasing to actual DB, it stores a record of what files got released. Of course, it is all automated and hooked into the main rel system. | |
| Apr 12, 2017 at 7:31 | history | edited | CommunityBot |
replaced http://programmers.stackexchange.com/ with https://softwareengineering.stackexchange.com/
|
|
| Nov 16, 2014 at 12:34 | comment | added | Richard | If you got this work please would show an example script? I'm trying to do this too but I don't how to translate between MS Sql any MySql: stackoverflow.com/questions/26948916/… | |
| Oct 2, 2014 at 23:01 | answer | added | Erik Kaplun | timeline score: 0 | |
| Sep 21, 2012 at 12:39 | vote | accept | Julian H. Lam | ||
| Apr 27, 2012 at 18:48 | answer | added | Reactgular | timeline score: 0 | |
| Apr 27, 2012 at 18:45 | history | edited | Julian H. Lam | CC BY-SA 3.0 |
grammar fix
|
| Apr 27, 2012 at 18:37 | comment | added | Julian H. Lam | Haha, yes, you caught me. I'm trying to work around my own failings instead of solving them in the first place. | |
| Apr 27, 2012 at 18:27 | comment | added | FrustratedWithFormsDesigner |
But of course, you'd test your update.php or update.sql file in a test environment before applying it to the active database, right? And PHPMyAdmin is being blamed for the possible problems that might happen in such as script, maybe it's time to look into a different/better tool?
|
|
| Apr 27, 2012 at 18:15 | answer | added | jmruc | timeline score: 2 | |
| Apr 27, 2012 at 18:06 | answer | added | Kilian Foth | timeline score: 11 | |
| Apr 27, 2012 at 17:51 | history | asked | Julian H. Lam | CC BY-SA 3.0 |