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:268024 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
