How to commit custom script in source control & deployment
Most part of our changes are not going to be schema or any other db object changes but it will be from DDLs, inserts, updates and deletes
1. How to make sure DDLs supported in this auto deployment, this is not just for static tables but any data manipulation script for any table
2. How we can commit and deploy the custom script through source control
3. How ordering of scripts can be done when required, there can be situation where script 1 need to be run after script 3 and check in order can be different.
Thanks in advance!!