DBA Tool for SQL Server CE

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » SQL Server 2005 Compact Edition » DBA Tool for SQL Server CE

DBA Tool for SQL Server CE

Rate Topic

Display Mode

Topic Options

Author

Message

xuaxe

Posted Wednesday, December 17, 2008 10:16 AM

Forum 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

Ninja's_RGR'us

Posted Wednesday, December 17, 2008 10:24 AM

SSC-Insane

Group: General Forum Members
Last Login: Today @ 3:18 AM
Points: 21,359, Visits: 9,541

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

xuaxe

Posted Wednesday, December 17, 2008 10:26 AM

Forum 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

Robert Cain-464398

Posted Wednesday, December 17, 2008 3:25 PM

Forum 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

xuaxe

Posted Wednesday, December 17, 2008 3:31 PM

Forum 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

SQSQ

Posted Monday, August 15, 2011 11:54 AM

Forum 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 »

Permissions