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.



Sign In or Register to comment.