Can I use SQL Server Management Studio Express to work with SQL Server Everywhere?

Can I use SQL Server Management Studio Express to work with this...SQL Server Everywhere?

I bought VS2005 Pro and installed everything, including the Developers edition of SQL Server 2005.
I would love to play with this and try converting old Access desktop applications.
Unfortunately I am unsure how to create and modify a new database for SQL Server Everywhere using SSMSE.

I have several tables that have a thousand records or so used for ‘Look-Up’ tables and really need a way to import those tables.

Working within VS2005 and manually creating tables just isn’t cutting the mustard here…

What can I do?

no, you cannot work with SQL Mobile databases in SQL Express Mgmt Studio. if you have Access databases to convert over, have a look at the tools at www.primeworks.pt

Darren

|||Thanks Darren,

Hopefully Microsoft will come out with a GUI tool to help create / manage / structure SQL Server Everywhere databases and be available to Developers at no additional cost.
|||

Hey Rick and Darren,

Yes we are working on integrating SQL Server Everywhere with SQL Server Management Studio Express. However, I can not give out the timelines here.

Sweet news is not it!

Thanks,

Laxmi Narsimha Rao ORUGANTI, SQL Server Everywhere, Microsoft Corporation

|||

I have published today a new (still "Beta") version of SQL CE Console (I will change this name in the future, it's a promise!) that allows you to open and edit SDF files on the desktop. You just have to install the Everywhere CTP (or the desktop SQL Mobile bits in VS 2005, if your license allows) and you are off. Get the beta from this link:

http://www.primeworks-mobile.com/News/SCC_1.2.500Beta.html

Enjoy!

BTW: Feature suggestions are welcome!

|||

Hello Guys,

1) Think its important to hae SQL Server Management Studio Express to work with SQL Server Everywhere.

2) In the meantime, can anyone advise how to convert an existing SQL Server express database to a SQL Server Everywhere?

regards

|||

Check my site for database conversion tools:

www.primeworks-mobile.com

|||

Hi,

I did, but there is an error on using the tool "Cannot open Dataport"

regards

|||Please use the site's support forum to discuss this issue.

Can I install sql server april ctp with sql server express already installed

Can I install sql server april ctp with sql server express already installed
This is within vs2005 beta2.

A related question. Are any of the later sql server 2005 ctps compatible with vs studio 2005 beta2?

Thanks in advance.

dennistHi,

I do not recommend you to run express and CTP side by side, because there are known isuess. I for example coul not use the Sql Server tools.

Sql Servr only runs with the .net version it was shiped. So having an earlier or later version may cause problems.