Hi, we have tons of SQL scripts with CREATE this UPDATE that etc etc,
all nicely time stamped.
These are currently run manually, but I was thinking about writing a
tool to handle this, but first wanted to check if one existed already.
Basically it would have to work like Rails or Sequel migration does,
know which files have not been ran, and then run them in.
Does anyone know of a tool/gem that does this for plain/raw SQL files?
Hi, we have tons of SQL scripts with CREATE this UPDATE that etc etc,
all nicely time stamped.
These are currently run manually, but I was thinking about writing a
tool to handle this, but first wanted to check if one existed already.
Basically it would have to work like Rails or Sequel migration does,
know which files have not been ran, and then run them in.
Does anyone know of a tool/gem that does this for plain/raw SQL files?
This wheel has been invented… Use activerecord or sequel and have the
.rb file run the raw sql.