SQL Server question

[Schreck, Tom]

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