A newb question.
Can I use migrations if all of the following requirements are imposed at
the same time.
Copy data from an old schema to a new schema, the difference in the 2
schemas is about 25%, 3 new tables and 4 new columns.
Copy data from Oracle schema to DB2 schema, around 25% difference in
2 schemas as above.
Neither old nor the new schema tables have an ‘id’ field.
developers (like me) donot have permission to execute ‘CREATE TABLE’
or ‘DROP table’.
Some of these restrictions are ridiculous but none theless they exist in
a typical beurocratic work culture.
Any ideas if I should use migrations (high level) or should I write low
level ruby scripts using OCI8/Ruby-DB2 interfaces.
thanks in advance