In the Connection Properties dialog box, enter the server name where the TradeDev database resides and make sure that correct authentication credentials are provided. In the Schema section, click the Database radio button, then click the New Connection button. Select the Project radio button, and then select the TradeDev database project you have created in the previous procedure.įrom the Select Target drop-down in the Schema Compare Window, choose Select Target, and the Select Target Schema dialog opens. Notice that if you opened the Schema Compare window by right-clicking the project name, the source schema is already populated and you can proceed to step 4. In the Select Source drop-down, choose Select Source and the Select Source Schema dialog opens. These menus allow you to select database definitions for your comparison source and target. Two drop-down menus with a green arrow in between them appear just below the Schema Compare window toolbar.
The Schema Compare window opens, and Visual Studio automatically assigns it a name such as SqlSchemaCompare1. On the Tools menu, select SQL Server, and then click New Schema Comparison.Īlternatively, right-click the TradeDev project in Solution Explorer, and select Schema Compare.
#Compare definition Offline#
The following procedures utilize entities created in previous procedures in the Connected Database Development and Project-Oriented Offline Database Development sections. The following procedure compares the schema of a database project with a connected database. Then you can save the comparison so that you can easily repeat the same comparison later or use it as the starting point for new comparison. You can also set options that control the scope of the comparison and aspects of the update. You can save comparisons either as part of a SQL Server Database project or as a standalone file. You can then selectively exclude specific differences. You can drill into and review each difference in the results grid or in script form. The differences between source and target appear in a grid for easy review.
#Compare definition update#
Once the comparison is complete you can update the target directly (if the target is a project or a database) or generate an update script that has the same effect. The results of the comparison appear as a set of actions that must be taken with the target to make it the same as the source. The source and target of the comparison can be any combination of connected database, SQL Server database project or snapshot or.
SQL Server Data Tools (SSDT) includes a Schema Compare utility that you can use to compare two database definitions.
0 kommentar(er)
