I would work out either: [] a BCP out process which exports data
or [] a DTS which exports specific data These are the easiest ways to get data out of SQL Server, and the fastest. David L. Penton, Microsoft MVP JCPenney Application Specialist / Lead "Mathematics is music for the mind, and Music is Mathematics for the Soul. - J.S. Bach" [EMAIL PROTECTED] Do you have the VBScript Docs or SQL BOL installed? If not, why not? VBScript Docs: http://www.davidpenton.com/vbscript New SP3 SQL BOL: http://www.davidpenton.com/sqlbol ---------- Original Message ----------- From: "Schreck, Tom" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thu, 4 Sep 2003 09:24:34 -0500 Subject: SQL Server question > 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 ------- End of Original Message ------- ----------------------------------------------- To post, send email to [EMAIL PROTECTED] To unsubscribe: Send UNSUBSCRIBE to [EMAIL PROTECTED] To subscribe / unsubscribe: http://www.dfwcfug.org
