Sam,
If you are looking for a CFC-based ActiveSchema solution, I would
humbly suggest you take a look at DataMgr:
http://steve.coldfusionjournal.com/schema_synchronization_with_datamgr.htm
Same syntax for any supported database. No custom tags. No need to
write any SQL.
Only adds tables/columns, though, no way to go back in time (open to
suggestions though).
Steve
At 01:48 PM 7/13/2007, Sammy Larbi wrote:
Hi Eric,
I actually didn't implement all that much in cfrails - simple up and
down for tables only, and you are right - it only works in MS SQL
Server (mainly due to the column type name differences for
autonumber fields).
Other than that, I think I've left the column type up to the
developer to avoid having to abstract that out myself (although this
will eventually change). Another glaring hole is that the included
runner doesn't respect version numbers, so you cannot go up and down
to specific instances in time (without writing your own script). I
also plan to change that behavior.
That said, migrations are low on the list of things I need to do for cfrails.
In any case, I do see value in it. I'm trying to move away from
tags, so I probably wouldn't use this version, but I'm sure some
people prefer tags!
Sam
You are subscribed to cfcdev. To unsubscribe, please follow the instructions at
http://www.cfczone.org/listserv.cfm
CFCDev is supported by:
Katapult Media, Inc.
We are cool code geeks looking for fun projects to rock!
www.katapultmedia.com
An archive of the CFCDev list is available at
www.mail-archive.com/[email protected]