Options
Command line or XML option to Specify Comparison Key
Dayl
Posts: 2 New member
I'm working on a legacy database and many of the table don't have a primary key specified.
I can set this in the Redgate UI app but how I specify it in the Redgate XML that I can then run from the command line?
Example of the UI config file
<TableActions type="ArrayList" version="1">
<value version="1" type="SelectTableEvent">
<action>UseCustomKey</action>
<val>[dbo].[bdm_import]:[dbo].[bdm_import]</val>
</value>
<value version="1" type="SelectTableEvent">
<action>SelectColumnAsKey</action>
<ColumnName>BDMID:BDMID</ColumnName>
<TableName>[dbo].[bdm_import]:[dbo].[bdm_import]</TableName>
</value>
</TableActions>
<value version="1" type="SelectTableEvent">
<action>UseCustomKey</action>
<val>[dbo].[bdm_import]:[dbo].[bdm_import]</val>
</value>
<value version="1" type="SelectTableEvent">
<action>SelectColumnAsKey</action>
<ColumnName>BDMID:BDMID</ColumnName>
<TableName>[dbo].[bdm_import]:[dbo].[bdm_import]</TableName>
</value>
</TableActions>
Example of XML file I can run from the command line
<include>Table:MBS_FULL</include><include>Table:MBS_CURRENT</include>
But how do add the comparison key to that?
Answers
<comparisonkeys>bdm_import:BDMID</comparisonkeys>