![]() If you are not able to see it or want to refresh, click on "Refresh Update Script" icon on the toolbar. The bottom pane shows the target schema update script depending on the selection of "Update Action" of each object. It marks the changes in different colors, the meaning of the color coding is available on the bottom of this pane as you can notice in the below screenshot. The next pane shows the object definition of the selected object. ![]() And finally the fourth column shows the name of the object at the target. Third column allows you to specify the kind of action which you want to take during synchronization for example if you want to Skip updating target, update target, drop from target if the object is missing in source, create on target if the object does not exist on the target. The next column shows the name of the object at the source. if the object is New, Missing, Equal or has a different definition. On the top pane there are four columns Status tells the type of change of each object i.e. The schema comparison result screen will look like the image shown below. You will notice a new tool bar, some of the options of this new tool bar are: you can filter out the comparison result as you can see in the image below, you can synchronize your target by writing updates to it (have a look on the note below before doing this), you can export your synchronization/incremental update script to a file or to the editor. The moment you click on the OK button, it will start doing the comparison. You can even save your selection as *.scmp file to use later on. The source or target could be either a database project (offline representation of your database) or the database itself (for which you need to set up a connection to your SQL Server instance) or a *.dbschema file. You will see a dialog box like this, here you need to specify your source schema and target schema. Select Schema Compare under Data menu and then New Schema Comparison as shown below. Open the Microsoft Visual Studio IDE (Integrated Development Studio) and you will see a "Data" menu in the menu bar depending on the Microsoft Visual Studio edition you have installed (for more details click here). ![]() In this demonstration I am going to show you how Schema Comparison works on Visual Studio 2010 Ultimate edition although you can do the same with Visual Studio 2005/2008 Database edition too. Microsoft Visual Studio Database edition offers several features for database development, for example you can create an offline representation of a database for database development and version control, Database Unit Testing, Code Analysis, Schema Comparison, Data Comparison etc. Although there are many tools available for schema comparison (some free and some you need to purchase) I am going to discuss the Microsoft Visual Studio Database edition for schema comparison. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |