How to perform views comparison in SQLDatacompare cmdline
nyathiraju
Posts: 1 New member
Views : doesn't have any unique index or primary key. Please guide.
sqldatacompare.exe /s1: /s2: /u1: /u2 : /p1: /p2: /include:table:<<viewname>> /include:identical /export:Pathlocation
Since views dont have primary key, how to perform view data comparison in cmdline without using SQLDatacompare UI.
How can I set comparisonkeys for views which doesn;t have index or primary key. Please do the needful
sqldatacompare.exe /s1: /s2: /u1: /u2 : /p1: /p2: /include:table:<<viewname>> /include:identical /export:Pathlocation
Since views dont have primary key, how to perform view data comparison in cmdline without using SQLDatacompare UI.
How can I set comparisonkeys for views which doesn;t have index or primary key. Please do the needful
Tagged:
Answers
You will need to add the following to the /options:Default,IncludeIndexedViews to your command line syntax, as per the example below:
sqldatacompare /server1:Staging001 /Database1:WidgetStaging server2:Production001 /Database2:WidgetProduction /options:Default,IncludeIndexedViews /verbose
Further reading available here:
https://documentation.red-gate.com/sdc/using-the-command-line/command-line-syntax/options-used-in-the-command-line
Senior Product Support Engineer
Redgate Software Ltd
Email: support@red-gate.com