Share via


Upgrade to SQL Server Compact Database

The Upgrade to SQL Server Compact 3.5 Database dialog box for SQL Server Compact 3.5 SP1 enables you to upgrade certain earlier versions of SQL Server Compact database (SQL Server Compact 3.5, and SQL Server Mobile, which was v. 3.0, and later versions). SQL Server CE, which was version 2.0, cannot be upgraded to SQL Server Compact 3.5 by using the Upgrade dialog box. To upgrade v. 2.0, you must use Upgrade.exe.

Note

The Upgrade to SQL Server Compact 3.5Database dialog box is available in SQL Server Management Studio, SQL Server Management Studio Express, and Server Explorer in Visual Studio.

Options

The following list contains details about the options available when upgrading a SQL Server Compact database file.

Password

You can enter a password to help secure the new database. You must enter a secure password.