Routes (SQL Server)

Routes appear in the routing table for the database. For outgoing messages, Service Broker determines routing by checking the routing table in the local database. For messages on conversations that originate in another instance, including messages to be forwarded, Service Broker checks the routes in msdb. PowerDesigner models routes as extended objects with a stereotype of <<Route>>.

Creating a Route

You can create a route in any of the following ways:

  • Select Model > Routes to access the List of Routes, and click the Add a Row tool.

  • Right-click the model (or a package) in the Browser, and select New > Route.

Route Properties

You can modify an object's properties from its property sheet. To open a route property sheet, double-click its Browser entry.

The following extended attributes are available on the Microsoft tab:

Name

Description

Owner

Specifies the owner of the route.

Scripting name: Owner

Remote service

[v2005] Specifies the name of the remote service to which the route points.

Scripting name: Service

Broker instance

Specifies the database that hosts the target service.

Scripting name: BrokerInstance

Lifetime

Specifies the amount of time, in seconds, that SQL Server retains the route in the routing table.

Scripting name: Lifetime

Address

Specifies the network address for the route. The next_hop_address specifies a TCP/IP address in the following format:

TCP://{ dns_name | netbios_name | ip_address } : port_number

Scripting name: Address

Mirror address

Specifies the network address for a mirrored database with one mirrored database hosted at the next_hop_address. The next_hop_mirror_address specifies a TCP/IP address in the following format:

TCP://{ dns_name | netbios_name | ip_address } : port_number

Scripting name: MirrorAddress