Differences between DLM and SQL Compare

10raw

What is the difference between the deployment script created by comparing two databases using SQL compare and a .sql script created by DLM automation while syncing two databases?

They look similar to me, Please let me know if there is any big impact of using one instead of other in any scenario.

Thank you .

Sergio R

Hi,

DLM Automation uses the SQL Compare engine to do the comparison and the deployment.

However DLM Automation uses different default SQL Compare options:
https://documentation.red-gate.com/sca3/automating-database-changes/automated-deployments/using-sql-compare-options-with-sql-change-automation-powershell-module/default-sql-compare-options-used-by-sql-change-automation-powershell-module

All other things being equal any differences in the deployment script can be explained by the different default options.

Please note that the license for SQL Compare does not allow for the tool to be used in CI processes, you should use SQL Change Automation instead. 

Kind Regards,