Export (0) Print
Expand All
0 out of 1 rated this helpful - Rate this topic

How to: Create a SQL Server Compact Database on a Server

In this topic, you will learn how to create a Microsoft SQL Server Compact 3.5 (SQL Server Compact 3.5) database on a computer that is running Microsoft SQL Server 2008.

  1. In SQL Server Management Studio, open Object Explorer.

    You can use SQL Server Management Studio or SQL Server Management Studio Express to create a database. You can install SQL Server Management Studio Express from Microsoft Download Center.

  2. In Object Explorer, click Connect, and then choose SQL Server Compact 3.5.

  3. In the Connect to Server dialog box, select <New Database…> from the Database file drop-down list.

  4. In the Create New SQL Server Compact 3.5 Database dialog box, type a file path and file name for the new database file. You can optionally select the default collation, case sensitivity, and choose whether you want to encrypt or password-protect the database. If you choose to encrypt or password-protect the database, type a password, and then click OK.

  5. Click Connect to connect to the new SQL Server Compact 3.5 database. The database is now displayed in Object Explorer.

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback
© 2014 Microsoft. All rights reserved.