Well, you could copy the entire database over then do a delete where the company does not equal the company you want.
Doug B. ----- Original Message ----- From: "Dan G. Switzer, II" <[EMAIL PROTECTED]> To: "CF-Talk" <cf-talk@houseoffusion.com> Sent: Monday, January 29, 2007 6:41 AM Subject: RE: Copying specific company data to a new database... > Doug, > > >Here is a little something that I found. > > > >http://www.sharewareconnection.com/export-schema-to-sql-for-sql-server.htm > > I can copy the entire database w/no problem. The issue is that I need to > take our database and create a copy that only contains the records from a > specific company. > > So it's got to be able to analyze the database starting at the table that > contains the companies and then figure out how to extract all the users and > their data. > > -Dan > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 & MX7 integration & create powerful cross-platform RIAs http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:267934 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4