Hi
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
-daya