AutomaticSchemaChange scripts
We've just implemented using SSC5 with Visual Studio GIT as our repository. I committed and pushed my first migration script and I just noticed that another folder was created aside from my commit under Custom Scripts folder as seen on the image.
Under the folder, there is a file AutomaticSchemaChange.patch which contains the full script fro creating the table including the add constraints statements. My only changes was I added a new column to the table for testing purposes. Just wondering why it creates this new folder and what is the purpose of the AutomaticSchemaChange.patch file. Our production database is a bit different from our test as we have 'CHECK' constraints enabled in prod but not in test, and I am not sure if the migration script will change them automatically.
Thanks
Comments
Hey Noel,
Thanks for contacting us!
The automatic schema change patch file is the initial Compare block - see documentation https://documentation.red-gate.com/display/SOC5/How+migration+scripts+work
When you go to deploy it, you can choose the "Ignore check constraints" or "Ignore WITH NOCHECK" comparison options if you are using SQL Compare or DLM Automation to deploy - documentation on that https://documentation.red-gate.com/display/SC12/Setting+project+options
Do let me know if you have any issues with that!
Technical Sales Engineer
Redgate Software