SqlScriptPublishModel fires ScriptItemsCollected event with duplicate URNs

When using SqlScriptPublishModel.SelectedObjects to provide URNs of objects to script, the application may have constructed the URN manually with user input.
During scripting, the URNs used to populate progress events are generated by SMO based on server and database queries. As a result the Server[@Name='myserver'] component of the output URN may be of a different case than that of the input URN, causing some internal dictionary lookups based on URN keys to fail. Applications will see this in the ScriptItemsCollected event where the ScriptItemsArgs.Urns collection may have multiple instances of the URN, differing only by the case of the server name component.

We found this in a sql tools service test case failure when the server name case in the local settings json file mismatches the server's self-reported name.

Commencez par SqlScriptPublishModel.SelectedObjects et l’événement ScriptItemsCollected, puis reproduisez l’échec à l’aide du cas de test SqlScriptPublishModelTests.cs référencé dans l’issue. C’est terminé lorsque la collection ScriptItemsArgs.Urns ne contient pas d’URN en double qui ne diffèrent que par la casse lorsque la casse du nom du serveur diffère.