RE: Copying specific company data to a new database...
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" > 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
Re: Copying specific company data to a new database...
I've got a script (used as a custom tag) that is built for SQL Server, that will do a cascading database delete, calling itself as often as necessary, based on the original record you want to delete. It requires that the DB tables be properly set up with foreign keys etc. The script digs around and figures out what records are dependent on each other, and basically deletes from the bottom up, finally deleting the initial record, the info for which was passed into the custom tag call to start with. If you're interested, I can email you the script. Dunno what DB server you're on though, so it may well be semi-useless to you. --Scott ~| 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:268026 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
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" 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
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" 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
Re: Copying specific company data to a new database...
Dan G. Switzer, II wrote: > I have a MSSQL database w/a lot of tables. I've got to copy all of a > company's data from one database into a brand new database. The database > should have all its foreign keys/primary key relationships defined (with one > exception.) > > I can write scripts by hand, but that will take a while. There's a lot of > work involved (disabling primary keys, reseeding indexes, etc.) > > Does anyone know of any good tools that will allow me to migrate the data to > a new database? > If you are really just copying the whole database (not just the schema) and then making a couple of changes, you might find it easiest to just restore a database backup as the new database and then make your changes. ~| 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:267930 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
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:267929 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Copying specific company data to a new database...
Here is a little something that I found. http://www.sharewareconnection.com/export-schema-to-sql-for-sql-server.htm Doug B. - Original Message - From: "Dan G. Switzer, II" <[EMAIL PROTECTED]> To: "CF-Talk" Sent: Monday, January 29, 2007 5:28 AM Subject: Copying specific company data to a new database... > I have a MSSQL database w/a lot of tables. I've got to copy all of a > company's data from one database into a brand new database. The database > should have all its foreign keys/primary key relationships defined (with one > exception.) > > I can write scripts by hand, but that will take a while. There's a lot of > work involved (disabling primary keys, reseeding indexes, etc.) > > Does anyone know of any good tools that will allow me to migrate the data to > a new database? > > Thanks, > 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:267926 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4