How to perform views comparison in SQLDatacompare cmdline

nyathiraju

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

Eddie D

Hi,
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