Naming your databases

The names you give databases, estimates, and address books must conform to Microsoft® SQL Server® requirements. These requirements are listed as follows.

  • The name cannot be empty.
  • The name must be comprised of letters, numbers, or underscores (_) only and must begin with a letter.
  • The name cannot have any spaces between characters ("white space").
  • The name must be less than 123 characters in length.
  • The name cannot have certain characters in succession. Examples of such characters in succession include "at" symbols (@@), single quotation marks (''), or pound signs (##).
  • The name cannot match certain key words reserved for SQL Server's own use, such as "Create," "Select," or "Insert."

If you convert Pervasive-based data for use with Microsoft SQL Server, the Data Migration Utility automatically appends any database names that do not meet this naming criteria.