Problem syncing Service Broker items
Have two service broker services that won't synchronise.
Database version shows,
CREATE SERVICE [//DBA/Login-Service]
AUTHORIZATION [dbo]
ON QUEUE [dbo].[Login-Queue]
(
[http://schemas.microsoft.com/SQL/Notifications/PostEventNotification]
)
GO
Source control version shows,
CREATE SERVICE [//DBA/Login-Service]
AUTHORIZATION [dbo]
ON QUEUE [dbo].[Login-Queue]
GO
When I try and commit the changes, it stops at the "Sending Files ..." step and says "Nothing to commit"
philcart
shared this idea
This has been fixed in v1.0. If you are still esperiencing any issues, please contact support@red-gate.com.
Thank you!
-
Thank you so much for providing the db and source control scripts. We are able to replicate your issue. We are parsing the service incorrectly when we script it out. Therefore, it thinks that nothing has changed, which is why you get that error. For now, please just ignore this service on your commit list. If you have multiple things to commit, the commit should work fine since other things have changed. This will always show up on your commit list until we can fix this. We have logged your issue (SOC-689) and are reviewing this.