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 2000 on windows XP

I have XP Pro installed on my system,Can I install SQL server 2000 InterpriseNo. Developers edition or MSDE, I believe.|||FWIW, I have SQL Server 2000 Personal Edition installed on my XP Pro workstation.

Terri|||Yep, forgot about that version. It used to be (SQL 7) you could install whatever version you want on whatever NT OS you wanted...|||I think SQL 2000 Enterprise can't be installed on XP|||I just wish they would updateChoosing an Edition of SQL Server 2000 to more accurately reflect the OS on which each can run The info in that document is invaluable, but the OS info is old.

Terri|||I have the Client Tools of Enterprise Edition successfully installed on my XP machine.

Or are you talking about installing the Server?
JK|||yep I M tlking about server|||Basically YES, YOU CAN!. Believe it or not I had my SQL Server on my XP Prof ed.

How come??? Well, I have 2 hard-drive on my PC, the first one I used XP and the second one I use W2k Prof ed (*dual booting) But I install the SQl Server on the XP hard-drive, and it works perfectly!!, It seems in SQL Server installation proccess they were scanning some unique file which is belong to the W2k files.

So the solution of your problem is try to put another hard-drive on your PC with W2k OS, then install your SQL Server on the XP hard-drive, after the installation you can return the W2k hard-drive. "Semoga bermanfaat!, Terima kasih."|||Of course, Yes. There is nothing wrong with SQL 2K server on XP Pro, I have done such install on my notebook, it runs perfect.|||I am Talking about ZP Home Edition|||Sorry Its XP Home Edition