This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(0, 38%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJL%3C/text%3E%3C/svg%3E)
I am trying to use VS SQL Server Database Project to publish a database to upper levels.
Question: Is there a way to publish objects in sequence? For example, tables first before views, FNs before SPs, certain SPs before another SPs, etc, etc?
OR does sequence not matter?
Thank you
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(240, 3%, 33%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EG%3C/text%3E%3C/svg%3E)
If you use the SQL Server Data Tools (SSDT) in your database project, SSDT should handle the deployment order, i.e., tables before views, functions before stored procedures. If you wan to control some object deployment orders, you can use the pre- or post- deployment script. Each database project can only have one pre- or/and one post- deployment script.
Isn't SSDT used more for SSIS packages?
Do you have a good example of Pre-Post deployments? Or is it just a list of which *.sql to execute?
SSDT is more used for the database project. When you create a database project, you can create a pre- or post- deployment script. In either script, you can list the script to be executed or write the direct code there. For example, if you want to add some seeded values into a table, you can create a script with NON as the build action (in the properties) and then list that file in the post-deployment script. That file will be executed after the objects are deployed. It secures the existence of the table when the seeded values are inserted into it.