Remote service bindings
A remote service binding specifies the security context for conversations that target a remote service. It instructs SQL Server which user or certificate should be used when initiating a conversation with a service outside the local database.
In Database Explorer, you can perform operations on remote service bindings by using the shortcut menu. Right-click a remote service binding in Database Explorer to access commands for specific tasks, such as editing, deleting remote service bindings, or generating scripts for them.
Create a remote service binding
You can create a remote service binding in SQL Editor in one of these ways:
- Code completion to write a script.
- SQL snippets to insert predefined or custom code.
Edit a remote service binding
1. In Database Explorer, right-click the remote service binding you want to edit and select Modify via SQL.
2. In a SQL document, update the ALTER REMOTE SERVICE BINDING statement.
3. On the SQL toolbar, click Execute or press F5.
Delete a remote service binding
1. In Database Explorer, right-click the remote service binding you want to delete and select Delete, or press Delete.
2. Click Yes to confirm the deletion.
Note
You cannot undo the drop operation, as this action permanently deletes the remote service binding. To avoid data loss, back up the database before deleting the remote service binding.
Generate a script for a remote service binding
1. In Database Explorer, right-click a required remote service binding and select Generate Script As, then select the statement type.
2. Select one of the following output options:
- To New SQL Window – Opens the script in a new SQL document.
- To File – Generates the script to a .sql file.
- To Clipboard – Copies the script to the clipboard.
For more information, see Generate the DDL and DML statements for database objects.
View properties of a remote service binding
To view properties of a remote service binding, in Database Explorer, right-click the remote service binding or Remote Service Bindings node and select Show Details.
Object Viewer opens, displaying detailed information about the remote service binding.
Refresh the remote service binding
To update the remote service binding to reflect the latest changes, in Database Explorer, right-click the remote service binding or Remote Service Bindings node and select Refresh, or press F5.
Open the Properties window
To open the Properties window, in Database Explorer, right-click the remote service binding and select Properties, or press F4.
Filter remote service bindings
1. In Database Explorer, right-click the Remote Service Bindings node and select Filter.
2. In the Filter Settings (Remote Service Bindings) dialog, configure the filter parameters.
3. Click OK to apply the filter.
Note
When you open the Remote Service Bindings node, the number of objects it contains appears in parentheses next to the node name. This number changes based on your filter settings.
Shortcut menu options for a specific remote service binding
The following table describes the shortcut menu options, which appear when you right-click a specific remote service binding in Database Explorer.
| Name | Description |
|---|---|
| Modify via SQL | Opens the existing route in a new SQL document containing an ALTER REMOTE SERVICE BINDING statement to update it. |
| Source Control > Source Control Manager | Opens Source Control Manager, where you can track and manage changes to database schema and static data. When Source Control Manager is already open, this option refreshes it. |
| Source Control > Commit | Opens Source Control Manager with all local changes (if any) selected and ready to commit. When Source Control Manager is already open, this option refreshes it and selects all local database changes. |
| Source Control > Get Latest | Opens Source Control Manager with all remote changes (if any) selected, ready to pull using Get Latest. When Source Control Manager is already open, this option refreshes it and selects all remote database changes. |
| Generate Script As | Generates a script of the selected object using the CREATE, DROP, DROP and CREATE, and ALTER statements. The script can be saved to a new SQL document or to a file, or copied to the clipboard. |
| Show Details | Opens Object Viewer that displays object details. |
| Delete | Drops the selected object from the database. Shortcut: Delete |
| Refresh | Updates the object to reflect the latest changes. Shortcut: F5 |
| Properties | Opens the Properties pane to view the object information. Shortcut: F4 |
Shortcut menu options for the Remote Service Bindings node
The following table describes the shortcut menu options, which appear when you right-click the Remote Service Bindings node in Database Explorer.
| Name | Description |
|---|---|
| Source Control > Source Control Manager | Opens Source Control Manager, where you can track and manage changes to database schema and static data. When Source Control Manager is already open, this option refreshes it. |
| Source Control > Commit | Opens Source Control Manager with all local changes (if any) selected and ready to commit. When Source Control Manager is already open, this option refreshes it and selects all local database changes. |
| Source Control > Get Latest | Opens Source Control Manager with all remote changes (if any) selected, ready to pull using Get Latest. When Source Control Manager is already open, this option refreshes it and selects all remote database changes. |
| Filter | Opens the Filter Settings dialog to control which remote service bindings should appear in Database Explorer. |
| Show Details | Opens Object Viewer that displays object details. |
| Refresh | Updates the object to reflect the latest changes. Shortcut: F5 |
Note
The Source Control shortcut menu is available only after you link the corresponding database to a source-control system.
Bulk operations
In Database Explorer, hold down Ctrl and select multiple remote service bindings. Then right-click the selection and select the required option.
The following table describes the shortcut menu options available for multiple remote service bindings.
| Name | Description |
|---|---|
| Source Control > Source Control Manager | Opens Source Control Manager, where you can track and manage changes to database schema and static data. When Source Control Manager is already open, this option refreshes it. |
| Source Control > Commit | Opens Source Control Manager with all local changes (if any) selected and ready to commit. When Source Control Manager is already open, this option refreshes it and selects all local database changes. |
| Source Control > Get Latest | Opens Source Control Manager with all remote changes (if any) selected, ready to pull using Get Latest. When Source Control Manager is already open, this option refreshes it and selects all remote database changes. |
| Source Control > Link/Unlink Static Data | Opens the Source Control Link Static Data dialog that displays the tables whose data you want to link. |
| Generate Script As | Generates scripts of the selected objects using the CREATE, DROP, DROP and CREATE, and ALTER statements. The scripts can be generated to a new SQL document or to a file, or copied to the clipboard. |
| Delete | Drops the selected remote service bindings from the database. Shortcut: Delete |
