On Tuesday, May 7, 2013 8:05:19 AM UTC-7, Charles Monteiro wrote: > > so we have to recreate Oracle's import / export utiltiy > > I see api for creation of tables , adding of indexes, batch inserts and > so forth but I can't readily see what's available for detecting of db > users/roles and the subsequent recreation of users. I see an execute_ddl > which is meant to be an internal api but i"ll admit that my background is > actually in object databases so I don't know if there's ddl that I could > use to create users. >
Sequel doesn't currently offer an abstraction for parsing or creating users. For some databases that Sequel supports, it wouldn't make sense. In any case, nobody has asked for it before, so I doubt it is a common need. You can use Database#run to run arbitrary SQL code, that's recommended over calling execute_ddl directly. > BTW, I should mention that the import/ export utility created would be for > Postgres. > > Now this begs why not use the native import / export utilities? well > because boss man is hoping for something that could also serve as a cross > db migration tool. I know there are tools/products that claim to do this, > but I"m tasked to do the research. > For migrating the data and basic schema (columns, simple indexes, foreign key constraints), Sequel can probably get you most or all of the way there. For anything more complex (users, access rights, functional/partial indexes, constraints, functions/triggers, etc.), you'll have to use other tools. Thanks, Jeremy -- You received this message because you are subscribed to the Google Groups "sequel-talk" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/sequel-talk?hl=en. For more options, visit https://groups.google.com/groups/opt_out.
