What are the challenges you face when working across database platforms? Take the survey

Service Broker is not a programmable object?

I'm just starting out using SCA (already been using SSC) and importing my existing database, but ran into a problem with the default options when the database makes use of Service Broker Queues.
The first migration script created attempts to create the Queue, but as the Queues all rely on stored procedures, and they are only added *after* migrations are run (as 'programmable objects') then the verify step will fail. The only solution I've found is on the project setting and to 'import into migration scripts' for programmable objects.

But I want to be clear that this means I'd no longer have the (extremely!) useful functionality of being able to inspect history, compare etc *all* programmable objects now? Am I relegated to a pure migrations approach now?

Are there other options I'm not aware of?

Best Answer

Sign In or Register to comment.