Change the Connection Associated with a Query

APPLIES TO: yesSQL Server yesAzure SQL Database yesAzure SQL Data Warehouse yesParallel Data Warehouse

A query can be executed against several different servers or databases by changing the connection used by the query.

To change the connection associated with a query

  1. In Query Editor, right-click a blank area of Query Editor, point to Connection, and then click Change Connection.

  2. In the Connect to Database Engine dialog box, provide the new connection information, and then click Connect.

See Also

Solution Explorer
Associate a Query with a Connection in a Project
View or Change the Properties of a Connection in a Project