DBA Tool for SQL Server CE

  • 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

  • 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).

  • Yes, but as far as I have tested it, it works only with SQL commands, that's why I do not like it.

  • 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.

  • Thanks, I found it in the data explorer of VS 2008

  • 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.

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply