Skip to main content
C
crikos
Inspiring
September 8, 2011
Question

DB Migrations

  • September 8, 2011
  • 1 reply
  • 677 views

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.

    This topic has been closed for replies.

    1 reply

    H
    henkemike
    Known Participant
    September 8, 2011

    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.

    C
    crikosAuthor
    Inspiring
    September 14, 2011

    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.

    Terms & ConditionsAccessibility statement
    Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices