How to: Create a SQL Server Compact 3.5 Database on a Connected Device

  • Article

In this topic, you will learn how to create a Microsoft SQL Server Compact 3.5 (SQL Server Compact 3.5) database on a device that is connected to a computer that is running Microsoft SQL Server 2008. For this procedure to work correctly, the device must be connected through ActiveSync.

To create a database on the server

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

  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, click Browse.

  5. Select the connected mobile device. Optionally, you can expand the Mobile Device node and select a folder, or create a new folder on the device. After you make your selection, click OK.

  6. Type a 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.

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

See Also

Other Resources

Working with Databases (SQL Server Compact)

Help and Information

Getting Assistance (SQL Server Compact 3.5 Service Pack 1)