winzamn.blogg.se

Select source drop-down list and click on the Select Source In the upper left corner of the SqlSchemaCompare query window, locate the To select source and target from their corresponding drop-down lists: This will load the SqlSchemaCompare query window and the first thing that needs to be done is

To compare two SQL databases with Visual Studio’s Schema Compare feature, follow these steps:įrom the main menu, go to the Tools -> SQL Server sub-menu -> On which additional testing should be done before moving to production. This is a neat feature, as it facilitates work for developers who are working on database development and need a quick way to synchronize the latest changes with the QA database, Among these features, Visual Studio offers users the feature to compare two SQLĭatabases via its Schema compare feature.īesides comparing SQL Server database locally or on the network, Visual Studio can connect and compare Azure SQLĭatabase as well. Visual Studio is an application that is used by many developers and it has different kinds of features that can facilitate the developer’s work.