how can I supress error "selected objects are identical..."

adriatikadriatik Posts: 1 New member
in SQL Compare

I am struggling with the compare tool in powershell to get the changes....

    $result = & "D:\Program Files (x86)\Red Gate\SQL Change Automation PowerShell\SC\SqlCompare.exe" /sca1:D:\Roles\RedGateDbPackages\Common\db\project\Common.sqlproj /server2:"." /database2:Common /o:idc,ie,ic,idsn,ifg,iup,if,ik,infr,ist /exclude:table:__MigrationLog /exclude:table:__SchemaSnapshot /exclude:view:__MigrationLogCurrent /exclude:Sequence  | Out-string

when I include identical I get all the identical list.
But I want just the changes...how I do that?
Tagged:
· Share on Twitter

Answers

  • Sergio RSergio R Posts: 610 Rose Gold 5
    I am afraid that without "include:identical" you will get an error if there are no changes.
     
    The suggested workaround would be to add some error handling code to your command instead of using "include:identical" 
    Sergio
    Product Support Engineer
    Redgate Software Ltd
    Please see our Help Center for detailed guides on how to use our tools
    · Share on Twitter
Sign In or Register to comment.