In Visual Studio, go to Tools -> SQL Server -> Schema Compare. Whether, will it be possible for us to have the changes auto-sync between SQL Management Studio to Visual Studio (or) by refreshing the Visual Studio Project. Further then, we manually copy the SQL Script from SQL Management Studio to Visual Studio Environment. We just need only those Stored Procedures to be sync with database environment.Īt present, we are making the changes to the Stored Procedures in the SQL Management Studio.
How to set the SQL Database Project in the Visual Studio 2017 connected to the Database? And Connecting to the Database should not allow Import option to extract the all other database objects such as Table, View from SQL to Visual Studio. In this approach, any changes in the stored procedure has to be copied and pasted on the stored procedure in the Project Solution. Instead of connecting to the Database from the Project Solution, I am using Import SQL Scripts. Purpose is to push only the Stored Procedure Changes to VSTS Git. I am working on SQL Database Project in the Visual Studio 2017.
0 kommentar(er)
