I have a schema for ~15 tables in MySQL. I need to migrate it to Oracle
though I’ve never used Oracle before. I see that Oracle doesn’t have an
auto_increment built in. One must create a trigger table for each
auto_incrementing id. I’m contemplating translating my MySQL schema
into a Ruby migration script.
Do you know if Ruby migrations will generate enough SQL to implement
these features seemlessly:
- auto increment id column
- foreign key constraints
- partition tables (by range on to_days())
- specify data column sizes (e.g. in SQL I can say varchar(10)) but in
my limited migrations exposure, it looks like the same column would be
described simply as string.
I’d consider porting to migrations if it bought me a free translation to
Oracle SQL, including the triggers for auto increment, even if I had to
hand tune the result a bit. Otherwise I may wait and use migrations at
a later date.