How to: Resolve Change Conflicts in "Quadrant"
[This content is no longer valid. For the latest information on "M", "Quadrant", SQL Server Modeling Services, and the Repository, see the Model Citizen blog.]
In this topic, you simulate a multi-user environment by making edits in open instances of both Microsoft code name “Quadrant” and SQL Server Management Studio and then resolve the conflicts that result from those changes.
This is the fifth topic in the "Quadrant" Pet Shop Tutorial.
Note
This topic requires that you use SQL Server Management Studio.
To resolve change conflicts
In “Quadrant”, open the MSPetShop4 database and open the Product table. For more information, see How to: Edit Stale Data in "Quadrant".
Open SQL Server Management Studio.
In SQL Server Management Studio, expand Databases, expand MSPetShop4, and then expand Tables.
Right-click dbo2.Product and click Edit Top 200 Rows.
Find the product named Pelican3 and change the name to Pelican4. Click on another row cell to commit the change.
Find the product named Penguin and change the name to Penguin2. Click on another row cell to commit the change.
Return to “Quadrant”. Do not press F5 or refresh the view.
Change the value "Pelican3" to "Pelican5".
Change the value "Penguin" to "Penguin3".
Press CTRL+S to save the changes.
Note the exclamation marks that appear in the "Pelican5" and "Penguin3" rows. This indicates that there are conflicts for those rows.
In the lower right corner of the “Quadrant” interface, double-click Changes. You can now see the conflicts.
In the left panel, click Pelican5 to see the proposed, original, and database changes for the field.
In the left panel, click Penguin3 to see the proposed, original, and database changes for the field.
In the right panel, right-click and note that you can either Resolve Field or Revert Field.
If you click Resolve Field you can use one of the three values: proposed, original or database.
In the left panel, right-click and note that you can select either Resolve All or Revert Changes.
If you select Resolve All, you can resolve all conflicts using one of the three values.
Right-click the left pane and click Resolve All, then click As Database. This resolves all conflicts by using the current database values. Alternatively, you can resolve the conflict by using the proposed value or the original value.
Save the changes. The workpad refreshes.
Note that in the lower right corner of “Quadrant” the Changes text has disappeared.
In this topic you have learned how to use “Quadrant” to view data from three different sources, and how to resolve the conflict.
The next topic in this series is How to: Edit Complex Data in "Quadrant".
See Also
Tasks
How to: Create a Database from "M" in "Quadrant"
How to: Explore Data In "Quadrant"
How to: Edit Stale Data in "Quadrant"