SQLCE 3.5 and Management Studio 2005 - Ginny Caughey [MVP] |
03-Dec-07 10:37:52
|
No, SSMS 2005 doesn't support SqlCE 3.5. As an alternative to SQL 2008, VS
2008 data tools work with SqlCE 3.5.
--
Ginny Caughey
Device Application Development MVP |
 |
| |
SQLCE 3.5 and Management Studio 2005 - Christian Resma Helle |
03-Dec-07 10:47:55
|
That's true. I created the database in VS 2008. I was just curious coz I
prefer using the management studio.
Thanks!
--
Regards,
Christian Resma Helle
http://christian-helle.blogspot.com |
| |
| |
SQLCE 3.5 and Management Studio 2005 - Ginny Caughey [MVP] |
03-Dec-07 10:53:39
|
Christian,
I prefer SSMS myself, so I certainly understand.
--
Ginny Caughey
Device Application Development MVP |
| |
| |
SQLCE 3.5 and Management Studio 2005 - ErikEJ |
03-Dec-07 11:51:15
|
As an alternative you could use the "Data Port Console" from PrimeWorks.
It works with version 3.1 and 3.5 on the desktop, and 2.0 and later on
devices.
Quite similar to SSMS, but more features: (Export, Import, Diagrams etc)
--
Erik Ejlskov Jensen, Mobile App Dev MCTS
Check out my SQL Compact blog at
http://erikej.blogspot.com |
| |
| |
SQLCE 3.5 and Management Studio 2005 - Christian Resma Helle |
03-Dec-07 01:50:26
|
Cool! I'll download the trial and see what it can offer! Do you use it
yourself?
--
Regards,
Christian Resma Helle
http://christian-helle.blogspot.com |
| |
| |
SQLCE 3.5 and Management Studio 2005 - ErikE |
04-Dec-07 08:02:01
|
Yes, occasionally, in particular now that I have to work with both 3.0 and
3.5 file formats.
--
Erik Ejlskov Jensen - MCTS: Mobile App Dev |
| |
| |
SQLCE 3.5 and Management Studio 2005 - Serge Wautier |
08-Jan-08 05:33:42
|
Hi Ginny,
I'm a total newbie regarding SqlCE. And I'm no SSMS expert neither.
I just installed SqlCE 3.5 on my dev machine. Opened SSMS 2005. Went to
Connect/Sql Server Mobile. Create a DB, created tables into it. Ran queries
against it. Everything worked like a charm.
... Except for one problem: There's no 'Open Table' menu item :-(
Do you have any explanation to offer as to why support seems complete at
first sight but oddly lacks the data grid, even though data queries work
fine.
TIA,
Serge.
http://www.apptranslator.com - Localization tool for your applications |
| |
| |
SQLCE 3.5 and Management Studio 2005 - Ginny Caughey [MVP] |
08-Jan-08 08:05:01
|
Serge,
I don't know the inner workings of SSMS - only that the SSC team at
Microsoft has advised that SSMS 2008 is the target for support for SSC 3.5.
I assume the database you created with SSMS 2005 was a SSC 3.1 database.
There is no Open Table menu for SSC databases in SSMS 2005.
--
Ginny Caughey
Device Application Development MVP |
| |
| |
SQLCE 3.5 and Management Studio 2005 - Serge Wautier |
08-Jan-08 08:59:51
|
Ginny,
Thanks for your answer.
Actually, I thought I had created a SSC 3.5 DB using SSMS 2005. But it
appears it's probably a 3.1 indeed: I tried to open the DB using PrimeWorks
Data Port Console and it complained. OTOH, I could not open a SSC 3.5 DB
created with Data Port Console using SSMS 2005.
Oh my, I guess I'll stick to Data Port Console or I'll take advantage of the
opportunity to install VS2008
Regards,
Serge.
http://www.apptranslator.com - Localization tool for your applications |
| |
| |