SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


DBA Tool for SQL Server CE


DBA Tool for SQL Server CE

Author
Message
xuaxe
xuaxe
SSC-Enthusiastic
SSC-Enthusiastic (141 reputation)SSC-Enthusiastic (141 reputation)SSC-Enthusiastic (141 reputation)SSC-Enthusiastic (141 reputation)SSC-Enthusiastic (141 reputation)SSC-Enthusiastic (141 reputation)SSC-Enthusiastic (141 reputation)SSC-Enthusiastic (141 reputation)

Group: General Forum Members
Points: 141 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
Ninja's_RGR'us
Ninja's_RGR'us
SSC Guru
SSC Guru (155K reputation)SSC Guru (155K reputation)SSC Guru (155K reputation)SSC Guru (155K reputation)SSC Guru (155K reputation)SSC Guru (155K reputation)SSC Guru (155K reputation)SSC Guru (155K reputation)

Group: General Forum Members
Points: 155594 Visits: 9672
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).
xuaxe
xuaxe
SSC-Enthusiastic
SSC-Enthusiastic (141 reputation)SSC-Enthusiastic (141 reputation)SSC-Enthusiastic (141 reputation)SSC-Enthusiastic (141 reputation)SSC-Enthusiastic (141 reputation)SSC-Enthusiastic (141 reputation)SSC-Enthusiastic (141 reputation)SSC-Enthusiastic (141 reputation)

Group: General Forum Members
Points: 141 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.
Robert Cain-464398
Robert Cain-464398
SSC-Enthusiastic
SSC-Enthusiastic (168 reputation)SSC-Enthusiastic (168 reputation)SSC-Enthusiastic (168 reputation)SSC-Enthusiastic (168 reputation)SSC-Enthusiastic (168 reputation)SSC-Enthusiastic (168 reputation)SSC-Enthusiastic (168 reputation)SSC-Enthusiastic (168 reputation)

Group: General Forum Members
Points: 168 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.
xuaxe
xuaxe
SSC-Enthusiastic
SSC-Enthusiastic (141 reputation)SSC-Enthusiastic (141 reputation)SSC-Enthusiastic (141 reputation)SSC-Enthusiastic (141 reputation)SSC-Enthusiastic (141 reputation)SSC-Enthusiastic (141 reputation)SSC-Enthusiastic (141 reputation)SSC-Enthusiastic (141 reputation)

Group: General Forum Members
Points: 141 Visits: 1
Thanks, I found it in the data explorer of VS 2008
SQSQ
SQSQ
SSC-Enthusiastic
SSC-Enthusiastic (167 reputation)SSC-Enthusiastic (167 reputation)SSC-Enthusiastic (167 reputation)SSC-Enthusiastic (167 reputation)SSC-Enthusiastic (167 reputation)SSC-Enthusiastic (167 reputation)SSC-Enthusiastic (167 reputation)SSC-Enthusiastic (167 reputation)

Group: General Forum Members
Points: 167 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.
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum








































































































































































SQLServerCentral


Search