How to: Run a Script on a Database Other than the Current Default
Although each database project in Solution Explorer can have a default database reference, you can run a script on any database.
Note
The dialog boxes and menu commands you see might differ from those described in Help depending on your active settings or edition. To change your settings, choose Import and Export Settings on the Tools menu. For more information, see Visual Studio Settings.
To run a script on an existing database connection or reference
In Solution Explorer, right-click the script you want to run and choose Run On.
When the Run On dialog box appears, choose a database connection or a database reference from the list, and click OK.
To run a script on a temporary database connection
In Solution Explorer, right-click the script you want to run and choose Run On.
When the Run On dialog box appears, choose the <temporary reference> list item and click OK.
When the Connection dialog box appears, supply the connection information and click OK.
Note
The script runs using the temporary database connection. After the script runs, the connection is deleted.
See Also
Tasks
How to: Connect to a Database from Server Explorer