Check out RedGate Bundle or ApexSQL bundles. They will do schema and data, both have an API as well.
"This e-mail is from Reed Exhibitions (Gateway House, 28 The Quadrant, Richmond, Surrey, TW9 1DN, United Kingdom), a division of Reed Business, Registered in England, Number 678540. It contains information which is confidential and may also be privileged. It is for the exclusive use of the intended recipient(s). If you are not the intended recipient(s) please note that any form of distribution, copying or use of this communication or the information in it is strictly prohibited and may be unlawful. If you have received this communication in error please return it to the sender or call our switchboard on +44 (0) 20 89107910. The opinions expressed within this communication are not necessarily those expressed by Reed Exhibitions." Visit our website at http://www.reedexpo.com -----Original Message----- From: Nick G To: SQL Sent: Wed Feb 21 19:29:20 2007 Subject: Copying an entire schema 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:2740 Subscription: http://www.houseoffusion.com/groups/SQL/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.6
