Re: Creating a database in Compact edition? Help>>>>>

There are any number of ways to create a SQLCe database that include:
Use the Database/Server Explorer in Visual Studio (SP1) that includes the new SQLCe 3.1 support.
Use the SqlCeEngine object to create a database in code.
Setup syncronization with a SQL Server Workgroup or better DBMS.
Use ADO.NET 2.0 Syncroization Services to do the same.

I include examples of all of these techniques in my EBook...-
--
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
INETA Speaker
www.betav.com/blog/billva
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
Visit www.hitchhikerguides.net to get more information on my latest book:
Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)
and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook)
-----------------------------------------------------------------------------------------------------------------------
"Anders Altberg" <anders.altberg> wrote in message news:%231MITu2fHHA.408@xxxxxxxxxxxxxxxxxxxxxxx
Erik
The Express edition DOES support CE. At least mine does.
Version Microsoft SQL Server Management Studio Express 9.00.3042.00.
CE version: 3.1

-Anders

"E®!k Visser" <burod004@xxxxxxxxx> wrote in message news:uCKcY1BTHHA.1552@xxxxxxxxxxxxxxxxxxxxxxx
Chuck,
The Express edition of SQL Server Management Studio does not support CE.
Ýou need the full-version, like the one that comes with SQLServer 2005 Dev. Edition.
You can create a database in your code using SqlCeEngine.CreateDatabase()
hth
Erik


"Chuck Hecht" <checht@xxxxxxxxxxxxxxxxx> schreef in bericht news:%23ExPeV9SHHA.1636@xxxxxxxxxxxxxxxxxxxxxxx
I guess the first question is"

I use the SQL Server Management Studio Epress to create the Compact edition database. Correct?

The online help is telling me to open the Object Explorer in Sql server management studio , click connect
and then select SQL Server Compact Edition.......There is now option like that

What am I doing wrong?????






.

Relevant Pages
Loading