Hi Ann
Thanks for your help I manage to resolve. We need to to download Sonar code guard to integrate it with Red Gate SQL Change Automation for running the analysis.
Code Analysis for SQL Server command line - SQL Code Analysis - Product Documentation (red-gate.com)
Thanks
Sunil Bindra