December 17, 2008 at 10:16 am
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
December 17, 2008 at 10:24 am
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).
December 17, 2008 at 10:26 am
Yes, but as far as I have tested it, it works only with SQL commands, that's why I do not like it.
December 17, 2008 at 3:25 pm
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.
December 17, 2008 at 3:31 pm
Thanks, I found it in the data explorer of VS 2008
August 15, 2011 at 11:54 am
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.
•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