The oracle client has IMP and EXP to do this. Alternatively you can use Data Pump if you are on 10G.
On 2/22/07, Mike Chabot <[EMAIL PROTECTED]> wrote: > It highly depends on what database you are using. Is your database > Oracle? MS SQL Server has a lot of ways to accomplish this. > > -Mike Chabot > > On 2/21/07, Nick G <[EMAIL PROTECTED]> wrote: > > I have been assigned to research the possibility of having a program, > > application or script (or whatever) basically copy an entire schema; data, > > triggers, primary keys, table names, the whole kit and kaboodle. The Oracle > > SQL Developer does something like this, however you have to manually select > > each table, then create the primay keys, then create the triggers, and so > > on. I am looking to have this whole process automated. Something that > > Selects all the tables at a specific schema and justs make a mirror copy of > > it. Does anyone know where I can get something like this....buying software > > to do this is also a possibility I'd be willing to do. Thanks for your time! -- mxAjax / CFAjax docs and other useful articles: http://www.bifrost.com.au/blog/ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 & MX7 integration & create powerful cross-platform RIAs http://www.adobe.com/products/coldfusion/flex2/ Archive: http://www.houseoffusion.com/groups/SQL/message.cfm/messageid:2742 Subscription: http://www.houseoffusion.com/groups/SQL/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.6
