ReadyRoll Script Generator to create INSERT scripts with IN NOT EXISTS clause

kmananth84

Hi ,

Is there any way to tweek ReadyRoll so that INSERT scripts are generated with IF NOT EXISTS clause

Thanks
Ananth

Eddie D

Hi Ananth

You can edit the project configuration as per this help article:
https://documentation.red-gate.com/pages/viewpage.action?pageId=42539778

Look to change the Add object existence checks SQL Compare option from the default value False to become True.

<!-- "Add object existence checks" SQL Compare option -->
<SyncOptionIncludeExistenceChecks>False</SyncOptionIncludeExistenceChecks>

Many Thanks
Eddie