Create Database Dialog

The Create Database dialog box for Microsoft SQL Server 2005 Compact Edition (SQL Server Compact Edition) in SQL Server Management Studio and SQL Server Management Studio Express lets you create a new database on the desktop computer that can later be copied and deployed to a device that is running SQL Server Compact Edition.

Options

Enter the new SQL Server Compact Edition database file name

In the Filename text field, enter the path and name of the SQL Server Compact Edition 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 Edition database with the same name and replace it with the new database that you are creating.

Sort Order

From the Sort Order drop down list, select the database sort order you want to use.

Encrypt

Select the Encrypt check box if you want to encrypt the data in the database. If you choose 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 Edition 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.