Shrink & Repair - Advanced Properties
SQL Server Compact allows you to change database properties during a Shrink & Repair that can only be specified at creation, repair, or during a compact.
Options
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.
CaseSensitive
From the CaseSensitive drop-down list, select whether the database will be case sensitive. Case sensitivity is a rule in the collation that determines if string comparisons consider character case as a factor when determining if two strings are equal. Case sensitivity only applies to locales with languages that are case aware. By default string comparisons are case insensitive.
Password
In the Password text box, type the password you want to protect your database. If you chose to encrypt the database, you must enter a password.
ConfirmPassword
In the ConfirmPassword text box, re-type your password. If you enter a password you must type it again to confirm it.
EncryptionMode
From the EncryptionMode drop-down list, select the type of encryption used to protect your database. Encryption mode specifies the method used to encrypt the database file. For more details about available encryption modes for different database versions, see Upgrading from Earlier Versions (SQL Server Compact).