Create a Company Database

Use the New Database function to create a new company database.

Note: The Advanced Options tab is reserved for future use.

To create a new company database, follow these steps:

1. Right-click on TRAVERSE or any company database and select New Database, or click the New Company button on the toolbar. The New Company Database dialog box appears.

2. On the General tab, enter a three character ID of the new company in the Name text box. Only numbers and A-Z characters are allowed.

3. Enter a brief description of the company in the Description text box.

4. When creating a company database, you should estimate how big it will be when filled with data. If the initial size that appears in the Initial Size box is not large enough for what your database requires, change the number. Once created, the database size automatically grows as you add information. To change how the database grows (whether it be by megabytes or by percentages), use Microsoft SQL Server Enterprise Manager.

   Note: Each database limit when using MSDE is 2GB.

5. The Template Folder field displays the default path where the Server Manager template file is installed. Should you need to locate the Template.tsm file, use the Browse button to search for it.

6. To specify a location other than the default for your database, use the Options tab. You can also use the Options tab to define the Public Role as well as determine if you want to save your DTS package.

7. Click the = 4) BSPSPopupOnMouseOver(event)" CLASS="BSSCPopup">Copy Data tab to copy data from another company. You can use this tab for adding a second company, for splitting one company into two, or to have a test company.

8. Click OK. The Status tab appears and displays Server Manager’s progress as it creates the new company database.

9. When finished, Completed displays on the Status tab and the following message box appears: “New Company Database created. Refer to log for any messages.” Click OK.