This tool is awesome, but keep in mind that it will create a sql script that might take a long time to run for a large database. Sometimes it's better to do a backup/restore and then delete the extra tables/data.
Russ > -----Original Message----- > From: houseoffusion [mailto:[EMAIL PROTECTED] > Sent: Monday, January 29, 2007 7:09 PM > To: CF-Talk > Subject: RE: Copying specific company data to a new database... > > I use a tool called ApexSQL Diff. It's really useful for scripting > changes > between two databases (both data a structure). Therefore making it > relatively easy when moving between development / staging and production > servers. > > The tool is available from http://www.apexsql.com/sql_tools_diff.asp > > Niall. > > > -----Original Message----- > From: Doug Brown [mailto:[EMAIL PROTECTED] > Sent: 29 January 2007 14:24 > To: CF-Talk > Subject: Re: Copying specific company data to a new database... > > 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" <[email protected]> > 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:268044 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
