Build SQL Database Projects Easily in Azure Data Studio | Data Exposed

[@StalinSalgado]

Hello thanks fot the videos, I have 2 questions How could I make a name change to a column in an already created table? This would be possible, another question can you join this process with CI/CD?

[@Scleavers]

A couple of years ago I wrote a C# CLI to download the fresh copy of a schema, but the Projects extension is much better

[@drewskwierskoballa]

Glad to hear it - and the projects extension is now also available in VS Code if you'd prefer to work there.

[@wilberthantoniolopezaguilar]

Hi. Nice video. Is possible to configure mirroring or replication from a Docker contariner to another with Azure Data Studio on a Linux Laptop?

[@brunoillipronti8641]

Does it work with the PostgreSQL extension? by the way... if ADS add features for Postgres and MySQL, this is gonna become the go-to tool for A LOT OF developers/data analysts

[@drewskwierskoballa]

At this time support for Postgres projects is not incorporated into the database projects extension featured in this video, however there is some support for Postgres projects in Azure Data Studio through the Postgres extension. For a quick introduction: techcommunity.microsoft.com/t5/azure-database-for-postgresql/introducing-postgres-projects-in-azure-data-studio/ba-p/1330728 Support for MySQL is one of our top requests and is on the roadmap. It is tracked on the issue here: github.com/microsoft/azuredatastudio/issues/4904

[@markusandrehenriksen6030]

Yes it does :) v0.2.7 is out ATM.

[@theAnandKarna]

Database Administrator !! WOW

[@ralber01000]

I see no option to debug a stored procedure in Azure using SSDT or ADS. Please advise. Thank you

[@drewskwierskoballa]

The functionality for connecting the TSQL debugger is not available in Azure SQL database, utilizing print statements may be a suitable substitution.

[@TresorChun]

anyone answer me please, can you use azure database studio to connect to your webpages like myphp admin do?

[@drewskwierskoballa]

Support for connecting to MySQL databases in Azure Data Studio is being worked on! You can track this GitHub issue for notifications as it moves forward - github.com/microsoft/azuredatastudio/issues/4904

[@stephenmurphy8833]

can it do unit testing like ssdt?

[@drewskwierskoballa]

I does not have the C#-based unit testing from SSDT

[@satishvish88]

How we can do table data deployment like I want to deploy schema and data both for a table

[@drewskwierskoballa]

For deploying data with SQL projects you could leverage a post deployment script to insert/merge data.

[@lucianaaguiar2244]

Are this changes versioned?

[@drewskwierskoballa]

The database project can be checked into source control for version tracking - support for git is integrated with Azure Data Studio. docs.microsoft.com/sql/azure-data-studio/source-control

[@lucianaaguiar2244]

@@drewskwierskoballa thanks!!!!

[@taqveem]

why not just concentrate on making SSMS cross platform???