Renaming 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 Data Migration Utility automatically makes changes to the selected folder's name under some conditions, as outlined in the following table.

Renaming data folders
Condition Action
Whitespace exists in the folder name. Removes the whitespace.
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 Data Migration Utility 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.