How can we help you today? How can we help you today?

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


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?
adriatik
0

Comments

1 comment

Sort by
  • Sergio R
    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 R
    0

Add comment

Please sign in to leave a comment.