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!
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| ColdFusion MX7 and Flex 2 Build sales & marketing dashboard RIAâs for your business. Upgrade now http://www.adobe.com/products/coldfusion/flex2 Archive: http://www.houseoffusion.com/groups/SQL/message.cfm/messageid:2739 Subscription: http://www.houseoffusion.com/groups/SQL/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.6
