Export (0) Print
Expand All

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.

NoteNote:

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

  1. In Solution Explorer, right-click the script you want to run and choose Run On.

  2. 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

  1. In Solution Explorer, right-click the script you want to run and choose Run On.

  2. When the Run On dialog box appears, choose the <temporary reference> list item and click OK.

  3. When the Connection dialog box appears, supply the connection information and click OK.

NoteNote:

The script runs using the temporary database connection. After the script runs, the connection is deleted.

Community Additions

ADD
Show:
© 2014 Microsoft