Renaming your databases
After you identify the Pervasive data folder or folders containing the data you want to migrate, the Data Migration Utility confirms that the name of the selected folder or folders meets Microsoft® SQL Server® database requirements.
The Estimating Management Console automatically makes changes to the selected folder's name under some conditions, as outlined in the following table.
| Condition | Action |
|---|---|
| White space exists in the folder name. | Removes the white space. |
| The folder name contains non-digit and non-letter characters. | Replaces non-digit and non-letter characters with an underscored space ("_"). |
| The folder name begins with a non-letter character, a Transact-SQL reserved key word, or is empty. | Appends "STD_DATABASE" as a prefix to the folder name. |
| The folder name exceeds 123 characters. | Truncates the name to 123 characters. |
| A SQL Server database already exists with the same name. |
Appends "_" followed by a unique number to the suffix of the name. The number that the Estimating Management Console adds to the file name increments with each successive instance of a folder migrating with the same name. |
Refer to Naming your databases for more information about database naming requirements.
You can rename your databases, including estimate databases and standard databases. However, keep in mind that renaming a database can have the following issues.
- Renaming a database in the Estimating Management Console does not update the name in SQL Server. If you rename a database in the Estimating Management Console and try to install a new database with the same name, a SQL Server error results. If you receive an error message during database installation informing you a database already exists, it likely was renamed using the Rename function in the Estimating Management Console. Try installing the new database again but assign a different name to it.
- Renaming a database affects the database activation. If you rename a database, the Sage Estimating software presents you with a Reactivate Database prompt. Reenter the database registration information at the prompt.