Database schema upgrade tools?

[Dave Merrill]

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?

[Dave Merrill]

Repost w canonical subject, sorry.

Dave

[br...@bradwood.com]

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: br...@coldbox.org
ColdBox Platform: http://www.coldbox.org
Blog: http://www.codersrevolution.com 

 

 

--------- Original Message ---------

--
--
You received this message because you are subscribed to the Google Groups "ColdBox Platform" group.
For News, visit http://blog.coldbox.org
For Documentation, visit http://wiki.coldbox.org
For Bug Reports, visit https://ortussolutions.atlassian.net/browse/COLDBOX
---
You received this message because you are subscribed to the Google Groups "ColdBox Platform" group.
To unsubscribe from this group and stop receiving emails from it, send an email to coldbox+u...@googlegroups.com.
To post to this group, send email to col...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/coldbox/24e937fb-d5fd-44a6-a06b-4ae88cb7465c%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[Dave Merrill]

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

Any place else I should look for a community project?

Dave

On Sunday, October 16, 2016 at 4:26:49 PM UTC-4, Dave Merrill wrote:

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 to requests that come in while the the schema is being upgraded.

[Luis Majano]

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

_____________________________
From: Dave Merrill <enig...@gmail.com>
Sent: Monday, October 17, 2016 4:04 AM
Subject: [coldbox:26043] Re: Database schema upgrade tools?
To: ColdBox Platform <col...@googlegroups.com>

--
--
You received this message because you are subscribed to the Google Groups "ColdBox Platform" group.
For News, visit http://blog.coldbox.org
For Documentation, visit http://wiki.coldbox.org
For Bug Reports, visit https://ortussolutions.atlassian.net/browse/COLDBOX
---
You received this message because you are subscribed to the Google Groups "ColdBox Platform" group.
To unsubscribe from this group and stop receiving emails from it, send an email to coldbox+u...@googlegroups.com.
To post to this group, send email to col...@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msgid/coldbox/7480b53f-fbc2-4c51-b50f-2cf4374cfcc9%40googlegroups.com.

[Dave Merrill]

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

[Luis Majano]

Very early stages so far

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

To view this discussion on the web visit https://groups.google.com/d/msgid/coldbox/e88065c7-ba83-4e7e-b5e3-8c0ffa622624%40googlegroups.com.