Azure Data Studio is a data management and development tool with connectivity to popular cloud and on-premises databases. Azure Data Studio supports Windows, macOS, and Linux, with immediate capability to connect to Azure SQL and SQL Server. Browse the extension library for more database support options including MySQL, PostgreSQL, and MongoDB.
I have a sql database project (.sqlproj) which contains a lot of tables, views and stored procedure.
When I want to modify one of these objects, I have to open the related .sql file, make my changes, but I can't run the script because the statement always begins with CREATE, and the object, 99% of the time, already exists.
Every time, I have to change the CREATE with an ALTER, run the script, and rollback to CREATE (otherwise the build will fail).
Is it possibile to connect the project to a sql connection and apply the change of a single object?
I maybe be wrong, but in Visual Studio with SSTD there is an option like this.
I have a sql database project (.sqlproj) which contains a lot of tables, views and stored procedure. When I want to modify one of these objects, I have to open the related .sql file, make my changes, but I can't run the script because the statement always begins with
CREATE, and the object, 99% of the time, already exists. Every time, I have to change the CREATE with an ALTER, run the script, and rollback to CREATE (otherwise the build will fail).Is it possibile to connect the project to a sql connection and apply the change of a single object? I maybe be wrong, but in Visual Studio with SSTD there is an option like this.