We use Oracle; 9i and 10G.
> 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! > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Deploy Web Applications Quickly across the enterprise with ColdFusion MX7 & Flex 2. Free Trial http://www.adobe.com/products/coldfusion/flex2/ Archive: http://www.houseoffusion.com/groups/SQL/message.cfm/messageid:2743 Subscription: http://www.houseoffusion.com/groups/SQL/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.6
