×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Picking up IDs on auto data transfer or back porting them to source

Picking up IDs on auto data transfer or back porting them to source

Picking up IDs on auto data transfer or back porting them to source

(OP)
I have an application that feeds three sets of data, lets call them A, B and C from server X to server Y.

When item A gets posted into server Y, it gets issued ID numbers.  Before items B and C can be posted into the import tables on server Y, the ID number issued to item A needs to find its way back to X so that they can be included in the data export as a key field (or at least reliably matched up on the way across).
Does anybody have any ideas on how to do this?

Server X is running SQL 2008, server Y is running SQL 2000 (although the app does support 2005, so I could possibly upgrade it).

John
 

RE: Picking up IDs on auto data transfer or back porting them to source

Can you add the ID for item A from server X in the set that you transfer from X to Y?

If yes, you will have the pair: Y_ID and X_ID on server Y.
When you transfer set B, include the X_ID from server X, join on X_ID from server Y, grab the corresponding Y_ID and populate the foreign table.

The same for set C.

Hope I understood the question smile


 

pipe
Daniel Vlas
Systems Consultant

 

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close