Sorting Database Objects in Sync script
When we create a syncronization script we have diffrent order of objects from time to time. It is not very good for us, because it is hard to find out changes.
Could you please make that the order does not change (for example in alphabetical order).
Alexandr
shared this idea
-
Alexandr
commented
We would like the sinchronization script not to change from time to time. No matter what order is inside.
-
AdminEddie
(Admin, Redgate)
commented
The Deployment Script generated is created in dependency order, as a simple example - the tables that a view depends upon is created before the view is created.
So sorting the deployment script in alphabetical order may not be a good thing to achieve as this may break the dependencies between objects.
If you are looking to see what will be generated and the differences between objects in the comparison, generating an Interactive HTML report will be a better way of reviewing the differences.
If you are comparing the same differences each time, for example a compare between an existing schema and a new empty schema with the deployment script differs in some way each time you generate a deployment script. I would be concerned, if this is what is important to you, please submit a support ticket through the web portal: https://productsupport.red-gate.com/hc/en-us and clicking the big blue button "Submit a request" or email support@red-gate.com
Many Thanks
Eddie