Comparing Data Predicament
rduclos
Posts: 8
I am scripting all the data differences between 2 databases. My problem is that I have a 4 tables that the users allow to add stuff to, they use Identity columns for ID’s. I need to script the changes of theses tables with the scripts not setting the Identity column. Is this possible using the toolkit.
[code]Tables:
TABLE CodeType COLUMNS([ID], [Description])
TABLE FedCode COLUMNS([ID], [Code], [Description], [CodeTypeID])
TABLE StateCode COLUMNS([ID], [Code], [Description], [FedCodeID], [CodeTypeID])
TABLE DistrictCode COLUMNS([ID], [code], [Description] , [StateCodeID], [FedCodeID], [CodeTypeID])[/code]
Colum [ID] on all 4 tables is an identity column, but since the customers can add to them, the default data I am scripting may use the same id as the customer’s data. The scripts I generate are not generated using the customer’s data. I need to be able to generate the ids on the customers side and update the ids to match in all 4 tables.
Is there a way to do this using the Toolkit?
[code]Tables:
TABLE CodeType COLUMNS([ID], [Description])
TABLE FedCode COLUMNS([ID], [Code], [Description], [CodeTypeID])
TABLE StateCode COLUMNS([ID], [Code], [Description], [FedCodeID], [CodeTypeID])
TABLE DistrictCode COLUMNS([ID], [code], [Description] , [StateCodeID], [FedCodeID], [CodeTypeID])[/code]
Colum [ID] on all 4 tables is an identity column, but since the customers can add to them, the default data I am scripting may use the same id as the customer’s data. The scripts I generate are not generated using the customer’s data. I need to be able to generate the ids on the customers side and update the ids to match in all 4 tables.
Is there a way to do this using the Toolkit?
Thank you,
Ryan
Ryan
Comments
I would try it in Data Compare first to see how it works. If the problem is that you do not want to overwrite the database's identities, you can choose one or more alternate columns to match the rows of data, then exclude the identity column. If you absolutely need to use the identity column as a comparison key, you're going to end up overwriting the identities with the ones from the first database.