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