How to run/execute SQL scripts

Expand / Collapse
 

How to run/execute SQL scripts


Article ID: 50611 - Last Review: November 22, 2012

SUMMARY

The following article provides instructions for executing SQL scripts on a SQL Database.


NOTE:  Running SQL scripts should be performed by advanced users only.  SQL Management Studio will not prompt you before committing changes, as such making modifications directly through SQL rathern than using YourSite Explorer can cause unexpected results.


INSTRUCTIONS

Before beginning any SQL scripts or changes, always open ContactCenterClient, go to Tools => Management => Configuration and create a backup of your current configuration.

Verify that SQL Server Management Studio Express is installed:

NOTE: You should see the shortcut under Start=>All Programs=>Microsoft SQL Server=>SQL Server Management Studio

The SQL 2005 version can be downloaded here:

The SQL 2008 version can be downloaded here:


Once SQL Server Management Studio Express is installed, double-click the .sql file and it will automatically launch the program and prompt you to connect to the server.

  • If you have SQL express installed, the server name would be the computer name followed by sqlexpress (ex. “localhost\sqlexpress”).
  • If the full version of SQL is installed, the server name would be the computer name of the SQL server (ex. “localhost”).

You need to authenticate with a valid windows or SQL username and password. Typically, you can just click “Connect” with all of the defaults.


Next you need to select the CCMData Database and click Execute.


You should see a message in the bottom left corner stating that the query executed successfully.



Keywords:  how to run execute sql scripts





Rate this Article:
     

Add Your Comments


Name: *
Email Address:
Web Address:
Verification Code:
*
 

Details
Last Modified:Thursday, November 22, 2012
Last Modified By: amontpetit
Type: HOWTO
Article not rated yet.
Article has been viewed 6,687 times.
Options