How to rename a SWCS company database : Solatech, Inc.

Summary

This article explains how to rename a SWCS 4.2 company database.

The Microsoft SQL Server Management Studio Express tool must be installed on the computer that you will be using. This can be the server or a workstation. This can be downloaded from the Microsoft web site at http://www.microsoft.com/downloads/en/details.aspx?FamilyID=76EA83DA-4797-4F11-A834-456EE9DC3764
This document assumes you are using the SQL Server that was installed with the Solatech software.

Before you start

Make sure that the Solatech Window Covering Software is not running on any computer except the one that currently has the company.

Find the location of the database files

On the computer where the company database currently resides run the Solatech Window Covering Software.
From the File menu click File Manager.
Select the File type Companies.
Write down the Location. This is the folder where the company files are currently stored.
If you are moving the other files (products, reports, etc.) then write down the locations for each file type.

Get the login information for the database

Run Windows Explorer.
Navigate to the folder where the company files are stored.
Find the files for the company you want to move. There will be three files with the same name but different extensions. Find the file with a .psd extension.
Open the .psd file with Notepad.
Locate the words <Host> and </Host>. Between these words is the name of the SQL Server that contains the company database. Write this down.
Leave this file open as you will need to make a change in it later.

Rename the database from the current computer

Close SWCS.
Run Microsoft SQL Server Management Studio Express. To do this click Start, Programs, Microsoft SQL Server 2005, SQL Server Management Studio Express.
When prompted to login, select or enter the name of the SQL server that contains the company database.
Choose 'SQL Server Authentication' for the Authentication method.
Enter a user name of 'sa' and a password of 'swcs'.
Click Connect.
Expand the folder 'Databases'.
Right click on the database for the company you want to rename and choose Rename.
Enter the new name of the database. Use numbers and letters only and no spaces.
Press Enter to save your changes.
Close the management studio.

Edit the company files

That's it. No changes need to be made to the other computers running SWCS.

For more information, refer to the following knowledge base articles: