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! > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Macromedia ColdFusion MX7 Upgrade to MX7 & experience time-saving features, more productivity. http://www.adobe.com/products/coldfusion Archive: http://www.houseoffusion.com/groups/SQL/message.cfm/messageid:2741 Subscription: http://www.houseoffusion.com/groups/SQL/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.6
