Create Database

The Create Database dialog box for SQL Server Compact in Server Explorer in Visual Studio lets you create a new database on a desktop computer.

Options

Enter the new SQL Server Compact 3.5 database file name

In the Filename text field, enter the path and name of the SQL Server Compact database that you want to create. You can also click Browse to find an existing database that you want to overwrite. If you do not provide a file name extension, the default .sdf extension will be assigned to the file name.

Overwrite existing database file

Select the Overwrite existing database file check box to delete a SQL Server Compact database that uses the same name and replace it with the new database that you are creating.

Collation

From the Collation drop-down list, select the database collation you want to use. Collations specify the rules for how strings of character data are sorted and compared, based on the norms of particular languages and locales.

Case Sensitive

The case sensitive check box sets the case sensitivity of the collation if the locale is case aware.

Encrypt

Select the Encrypt check box if you want to encrypt the data in the database. If you want to encrypt the database, you must specify a password. This feature uses the Secure Sockets Layer (SSL) feature of Microsoft Internet Information Services (IIS) to encrypt data propagated between a device that is running SQL Server Compact and a computer that is running SQL Server.

New Password

You can, optionally, enter a password to help secure the new database. If you chose to encrypt the data, you must enter a password.

Confirm Password

Enter the same password again to confirm it.