DB Migrations

[crikos]

Hi everybody,

I am new to this forum and also to Coldfusion. right now I am "walking" from Ruby on Rails in direction Coldfusion9. Doing this I am playing around with the developer edition of CF and there rose up one big question:

How can I manage DB Migrations (changing the DB schema) ?

For explanation: in Ruby on Rails there is an integrated module called Migration, which allows me to work on different levels with different DB Schemas. One for production, one for development and one for testing purposes. After finishing a new Release I can easily switch form test or development environment to production environment (through migration). During such a migration the DB Schema will be changed to the new Version and all datasets are migrated too.

Is there any comparable function in Coldfusion or an external module available ?

Any suggestions are very appreciated.

[henkemike]

ColdFusion on Wheels has a Migration plugin. http://code.google.com/p/cfwheels-dbmigrate/

I cover it in my CFWheels training. It is a pretty interesting idea. I would more compare Ruby with CFML and Rails with Wheels.

[crikos]

Hi - Thank you very much for your comment. CFWheels seems to fill that gap and brings that two worlds closer together. I am developing with the Flex Framework and was using RoR, because it is an amazing Framework for Web development. But my issue for looking at Coldfusion was the support for AMF - which is in RoR bad and in Coldfsuion very good.