How to start SQL Server Compact after installation?

Question

Hello

I have downloaded this edition of SQL and run the installation. I have located the Microsoft SQL 2008 Server Compact folder, but not been able to find any file to launch it. Please give me instructions as to how to launch SQL Server Compact.

Thank you

Answer 1

Hi Dai,

read this about Sql Server CE:

http://msdn.microsoft.com/en-us/library/dd938877.aspx

hope it's helpful for you



-Harrie-

Answer 2

Hi,

To work with SQL CE Designers [create database, tables, etc.], you should have SQL Server 2008 Management Studio or Visual Studio 2008 installed in the machine. You can find detailed information on working with SQL Compact here: http://msdn.microsoft.com/en-us/library/ms172349.aspx

Thanks, Imran.

---

“This posting is provided "AS IS" with no warranties, and confers no rights”.

Answer 3

Thank you for the replies. I remember installing some components of Visual Studio 2008 Express on my PC which the CE has been installed on. Please let me know if I need to install the full edition of Visual Studo 2008 or if I could add some more components from the Express edition.

Regards,

Dai

Answer 4

Hi Dai,

You don't have to add another component unless you have to connect PC through mobile device, then you have to install active sync 4.5. You can download active sync here :

http://download.cnet.com/Microsoft-ActiveSync/3000-2094_4-10031823.html

Answer 5

Hello

I have Visual Studio 2008 Express installed on my Windows 7 Ultimate machine and yet any edition of SQL server does not launch - there is no icon to launch it on the Start menu. Any suggestions would be appreciated.

Cheers,

Dai 

Answer 6

SQL Compact is not a "program" it is a set of DDL files, which exposes a database API, that you (as a programmer) can include in your application. So you cannot "launch" it. See for example: http://en.wikipedia.org/wiki/SQL_Server_Compact

---

http://erikej.blogspot.com Erik Ejlskov Jensen - Please mark as answer, if this was it.