I have two MSSQL2008 databases DBA and DBB, DBA master-detection table pairs include: AMSTER, ADTT DBB also includes BMM and BD etail. The only difference is that the betwee A and B primary key type is the integer in the source database (DBA), but this is the unique identifier in the destination (DBB).
Dear Partner: How to describe the dataflow in SSIS to change this matter? I need to convert all the fields, but replace it with the new key type
If you do not want to store the natural primary key then how do you make the update, as if a record has changed in the source and you want to repeat this kind of change in the destination table, how would you do it, I mean Logically not possible Either keeps you should be integer-based natural keys in the destination table or you will keep mapping tables between old natural keys and related new key mapping information.
And the UID is still a big number and I do not think that the UID is a good option for changing the integer if you really want to do this, then do so. See more on INT >> hex STRING >> uid uid [
No comments:
Post a Comment