Friday, September 2, 2016

Can you connect to SQL Server Compact in SQL Server Management Studio?

Unfortunately no. It was once possible long ago.

You could however connect to SQL Server Compact using Visual Studio 2015 Community Update 3 (this is what I am using).

In addtion to this you should download and install the SQL Server Compact/SQLite Tool box extension for Visual Studio from here:

(https://github.com/ErikEJ/SqlCeToolbox).

Once you do this, you can access the tool box extension you added in Visual Studio and if you have a SQL Server Compact on your computer you can cconnect to it as shown here:


If the version of SQL Server Compact is 3.5 like mine was, the tool box upgrades it to version 4.0.

In Visual Studio 2008 or 2010 you could do this:

http://hodentekmsss.blogspot.com/2010/07/sql-server-compact-35-basics-you-must.html


https://www.packtpub.com/books/content/connecting-microsoft-sql-server-compact-35-visual-studio


No comments: