Database schema upgrade tools?

Communities ColdBox HMVC
1

Does ColdBox or a companion module have a way to manage modifications to an app’s db schema, similar to the CFWheels cbmigrations tool, but more generic?

The problem tools like this address is that after an app has been deployed, and you then make schema changes in dev, they need to be propagated out to the production db. In the case of an app that customers etc may be hosting themselves, they need to get those changes too, ideally without having to know exactly what changes are required, and regardless of what previous version they’re starting from.

In some other apps I’ve worked on, we had home-grown tools for checking the schema version stored in the db, and running UpgradeTo{n} methods or similar until the db was at the same internal version as the code, messaging the user, and logging any errors. Ideally, it’d also display an appropriate msg if requests that come in while the the schema is being upgraded.

Is there anything like that for ColdBox?

2

Repost w canonical subject, sorry.

Dave

3

If you’re using ColdFusion ORM there’s some options for schema changes, but there’s nothing official in ColdBox to handle that. I’m not sure if anyone has worked on a community project for this or not. I used to just use RedGate SQL Compare to keep schema in my SQL Servers the same.

Thanks!

~Brad

ColdBox/CommandBox Developer Advocate
Ortus Solutions, Corp

E-mail: brad@coldbox.org
ColdBox Platform: http://www.coldbox.org
Blog: http://www.codersrevolution.com

4

Thanks Brad, figured as much when I didn’t find anything in ForgeBox.

Any place else I should look for a community project?

Dave

5

Dave

Eric Peterson has beeen working on a migrations project. I will look for the links

Luis Majano
CEO
Ortus Solutions, Corp
www.ortussolutions.com
P/F: 1-888-557-8057

6

Thanks Luis. Do you mean this: https://github.com/elpete/cbmigrations

I haven’t had a chance to look at the code, and there don’t seem to be any docs other than that, but it looks from the outside like just what I’m looking for. Will check it out.

Dave

7

Very early stages so far

Luis Majano
CEO
Ortus Solutions, Corp
www.ortussolutions.com
P/F: 1-888-557-8057