It really comes down to a matter of your viewpoint. I can hear the questions now: Why would you use SQL Server Management Studio over Visual Studio to create and manage your SSCE database? Rather than repeating myself, I’ll suggest you take a look at yesterday’s blog entry for more details on creating tables and adding rows. If you pick “New Table” you will see the same dialog as yesterday. If you right click on the Tables, you’ll see the same menu. You are now brought to the standard SQL Server Management Studio interface.įrom here on, you’ll find things work almost identically to Visual Studio. I clicked “Remember Password” on then clicked the Connect button. SQL Server Management Studio has helpfully filled in the Database File name for you as well as the password. Now your database has been created, and you are brought back to the original “Connect to Server” dialog you saw. Either click no and enter a stronger password or click Yes to continue. Like yesterday, if you use a weak password you are warned. Remember if you do choose to encrypt, you must enter a password.

Like I said yesterday, I always encrypt and use a password, if you want to as well check Encrypt on and enter a password. Enter the name for your database, or browse for it. Now in the Database File area, click on the drop down and pick “”.Īfter picking the new database option, you should see a familiar looking dialog. First, you need to change the Server Type to “SQL Server Compact Edition”. When you launch SQL Server Management Studio, you are shown the normal “Connect to Server” dialog. Today I’ll show you how to create the same database using SQL Server 2005 Management Studio. Yesterday I showed you how to create a SQL Server Compact Edition database, using Visual Studio.

Visual studio 2017 sql server compact