IWETHEY v. 0.3.0 | TODO
1,095 registered users | 0 active users | 0 LpH | Statistics
Login | Create New User
IWETHEY Banner

Welcome to IWETHEY!

New Weekly change scripts
We have free reign to do as we please in the DV database. All database changes made during that week go into a numbered mod_schema_##.sql script. The client's DBAs then run this script (which we provide to them via email weekly) upon request.
-YendorMike

"They that can give up essential liberty to obtain a little temporary safety deserve neither liberty nor safety."
- Benjamin Franklin, 1759 Historical Review of Pennsylvania
New We do something like that.
But on an even smaller scale.

Given I am the DBA, and the developer for an internal app, most of the SQL changes I keep in version-specific files. The other 3 developers do changes in the local DB and then manually replicate them to production using MyAdmin (no, I don't like this, either). They are also conceptually resistant to version numbers in their product so I haven't even tried to get them to put SQL changes in versioned files...

Wade.
"Insert crowbar. Apply force."
New Oh, *that* process will scale well :-/
===

Purveyor of Doc Hope's [link|http://DocHope.com|fresh-baked dog biscuits and pet treats].
[link|http://DocHope.com|http://DocHope.com]
New Tell me about it.
If I lose development of my app, I will probably become the gatekeeper to the website releases. At which point, I will be insisting on version numbers and improving what currently passes for a release process.

Taking their access away from the database will be harder...

Wade.
"Insert crowbar. Apply force."
     How do you manage database changes? - (admin) - (21)
         Re: How do you manage database changes? - (JimWeirich) - (11)
             Mind responding to some rails criticism? - (ben_tilly) - (10)
                 I would be interested to see... - (admin) - (8)
                     A Nested Comments Example - (JimWeirich) - (7)
                         Either one of us is missing something, or Rails is magic - (drewk) - (6)
                             I Missed Something - (JimWeirich) - (5)
                                 Adjacency trees are simple. - (admin) - (4)
                                     Re: Adjacency trees are simple. - (JimWeirich) - (3)
                                         The arbitrary SQL somewhat answers my question... - (admin)
                                         Not what he meant - (drewk) - (1)
                                             Re: Not what he meant - (JimWeirich)
                 Re: Mind responding to some rails criticism? - (JimWeirich)
         Weekly change scripts - (Yendor) - (3)
             We do something like that. - (static) - (2)
                 Oh, *that* process will scale well :-/ -NT - (drewk) - (1)
                     Tell me about it. - (static)
         We make them independent of code, and do them first - (ben_tilly) - (2)
             Automated or no? -NT - (admin) - (1)
                 No - (ben_tilly)
         Two answers - (tuberculosis)
         Re: How do you manage database changes? - (dws)

The next steps I'm real fuzzy on.
74 ms