Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

DBA Tool for SQL Server CE Expand / Collapse
Author
Message
Posted Wednesday, December 17, 2008 10:16 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, December 17, 2008 3:27 PM
Points: 3, Visits: 1
Hi,
I have a .sdf SQLServer CE database file.
I want to view and edit data without SQL and create tables, etc... in my Windows XP desktop to develop an application
Is there any DBA tool to do that?
Thanks
Post #621428
Posted Wednesday, December 17, 2008 10:24 AM


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Thursday, August 28, 2014 4:00 AM
Points: 21,397, Visits: 9,612
Don't know for sure, but you can get management studio express (free download). Then see if you can connect (that's where I'd start, I never had to do this before).
Post #621436
Posted Wednesday, December 17, 2008 10:26 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, December 17, 2008 3:27 PM
Points: 3, Visits: 1
Yes, but as far as I have tested it, it works only with SQL commands, that's why I do not like it.
Post #621440
Posted Wednesday, December 17, 2008 3:25 PM


Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, June 12, 2009 8:38 AM
Points: 8, Visits: 21
I've used SQL Server Management Studio to create and modify SSCE databases, using no SQL. You can also do the same thing with Visual Studio using the Data Explorer. This was with SQL Server 2005 Compact Edition, is that the same version you are using? The 2005 edition also goes by SSCE 3.0 and 3.1, the version that shipped with 2008 was version 3.5.
Post #621671
Posted Wednesday, December 17, 2008 3:31 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, December 17, 2008 3:27 PM
Points: 3, Visits: 1
Thanks, I found it in the data explorer of VS 2008
Post #621673
Posted Monday, August 15, 2011 11:54 AM


Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, August 22, 2011 10:20 PM
Points: 5, Visits: 30
One of tools DBA might want is to generate database scripts for SQLCE.
SQLCE Scripter creates database schema and/or data insert scripts
for SQLCE 3.5 and SQLCE 4.0.

SQLCE Scripter Features
•Create SQL schema scripts for tables, indexes and referential relations.
•Create data scripts so that CE data can be moved to SQL Server or other data store.
•User can select specific tables only
•User can select Script Schema, Script Data or both.
•This version supports SQL CE 3.5 and SQL CE 4.0.
•SQL CE database migration can be done by executing generated scripts on other SQL Server or other database system.
Post #1160168
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse