Click here to monitor SSC
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
Forum Newbie
Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)

Group: General Forum Members
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
Ninja's_RGR'us
Ninja's_RGR'us
SSC-Insane
SSC-Insane (20K reputation)SSC-Insane (20K reputation)SSC-Insane (20K reputation)SSC-Insane (20K reputation)SSC-Insane (20K reputation)SSC-Insane (20K reputation)SSC-Insane (20K reputation)SSC-Insane (20K reputation)

Group: General Forum Members
Points: 20943 Visits: 9671
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
Forum Newbie
Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)

Group: General Forum Members
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.
Robert Cain-464398
Robert Cain-464398
Forum Newbie
Forum Newbie (8 reputation)Forum Newbie (8 reputation)Forum Newbie (8 reputation)Forum Newbie (8 reputation)Forum Newbie (8 reputation)Forum Newbie (8 reputation)Forum Newbie (8 reputation)Forum Newbie (8 reputation)

Group: General Forum Members
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.
xuaxe
xuaxe
Forum Newbie
Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)

Group: General Forum Members
Points: 3 Visits: 1
Thanks, I found it in the data explorer of VS 2008
SQSQ
SQSQ
Forum Newbie
Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)

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