This add-on (extension) helps you to compare schemas (structures) between your database project and the target database although it can compare schema between the two databases as well.įor those who are less familiar with it, I suggest to please consider this extension as a check and balance method If the Extensions page is still open then please look for “SQL Server Schema” this time and install it just like the way you installed the previous add-on (extension).Ī successful installation of the extension is shown as follows: There is just one more extension to go which is highly recommended if not mandatory.Īdding SQL Server Schema Compare Extension Once you get the add-on (extension) the job of creating database projects is going to be a piece of cake except if you end up doing something silly which can happen with anyone even the most talented developers do silly mistakes.Īnother way to understand this add-on is to visualize that you have just turned your Azure Data Studio into a SQLĭatabase Project development machine (tool). Please open Azure Data Studio and click on Extensions from the left navigation bar (or use the shortcut keyĬTRL+SHIFT+X) and look for “SQL Database Projects”.Ĭlick Install once you have selected the desired option:Īfter a couple of minutes or a little less than that the extension is going to be installed and ready to be used.

Let us now go through the steps to add these extensions. The two must-have extensions to build database projects are as follows: The first thing in this regard is to equip Azure Data Studio (after it is installed) with the capability of creatingĭatabase Projects and this is done by adding the required add-ons.

Interested to use Azure Data Studio using declarative database development.Īs with any other tool we need to first ensure that it is capable of serving the purpose and in our case, the purpose is to successfully build database projects. This article is also an in-time call for all those database or business intelligence developers or enthusiasts This article talks about the two standard ways of building SQL Database Projects in Azure Data Studio along with the simple steps of implementation.

Visual studio for mac database project