My concern with using DTS packages is ensuring the relational integrity of the data in the targeted SQL server. I have not worked with DTS packages before, so I'm not sure how it will handle maintaining relational integrity.
Tom -----Original Message----- From: Matthew Woodward [mailto:[EMAIL PROTECTED] Sent: Thursday, September 04, 2003 9:43 AM To: [EMAIL PROTECTED] Subject: Re: SQL Server question All these tasks are relatively easy to do from within SQL Server itself--do you have full access to the SQL Servers involved via Enterprise Manager, or are you having to try to do this programmatically from CF? I'm by no means a SQL Server DBA, but I've done a bit with DTS and you could definitely create a job within SQL Server that would do what you want. I guess whether or not this is the right solution for you depends on what acess you have to the servers and how you want the user to kick off the process. Matt ------------------------- Matthew P. Woodward [EMAIL PROTECTED] AIM: CaptainJavac http://www.mattwoodward.com ----Original Message Follows---- From: "Schreck, Tom" <[EMAIL PROTECTED]> Reply-To: [EMAIL PROTECTED] To: <[EMAIL PROTECTED]> Subject: SQL Server question Date: Thu, 4 Sep 2003 09:24:34 -0500 I need to copy bulk data between SQL Server 2000 databases. Is there an elegant way to tell SQL Server X to copy record Y from table Z to SQL Server A table B? I do not need replication because I do not want this to be an automatic process. It needs to be initiated by a user. Basically, I have 15 related tables whose data is set in a development zone. I need to promote the data set from these 15 tables to my staging zone and keep the relationships intact. I will need to repeat this process from staging to production once final approval is obtained. The data is the structural data for our public websites, so it's not like publishing content. In the past I did this with brut force by starting with the first table and worked my way through all relationships. This was easy enough when I was working with 6 tables. My back-end structure has grown to 15 tables that I need to promote and maintain relationships. Does this make sense? I'm afraid I'm going to have to hack through each table in order and maintain a structure of old and new identity fields so I have a reference point for keeping the relationships intact. Thanks - Tom Schreck 817-252-4900 [EMAIL PROTECTED] I have not failed. I've found 10,000 ways that won't work. - Thomas Edison _________________________________________________________________ Get 10MB of e-mail storage! Sign up for Hotmail Extra Storage. http://join.msn.com/?PAGE=features/es ----------------------------------------------- To post, send email to [EMAIL PROTECTED] To unsubscribe: Send UNSUBSCRIBE to [EMAIL PROTECTED] To subscribe / unsubscribe: http://www.dfwcfug.org ----------------------------------------------- To post, send email to [EMAIL PROTECTED] To unsubscribe: Send UNSUBSCRIBE to [EMAIL PROTECTED] To subscribe / unsubscribe: http://www.dfwcfug.org
