thanks
On Tue, May 7, 2013 at 11:39 AM, Jeremy Evans <[email protected]>wrote: > 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 a topic in the > Google Groups "sequel-talk" group. > To unsubscribe from this topic, visit > https://groups.google.com/d/topic/sequel-talk/3coQAdriPPA/unsubscribe?hl=en > . > To unsubscribe from this group and all its topics, 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. > > > -- Charles A. Monteiro www.monteirosfusion.com sent from the road -- 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.
