How can I manage SQL CE databases in SQL Server Management Studio?

Posted by Arul on Stack Overflow See other posts from Stack Overflow or by Arul
Published on 2010-04-12T11:18:52Z Indexed on 2010/04/12 11:23 UTC
Read the original article Hit count: 423

Filed under:

c#2.0

|

VS

|

2005

|

sqlserverce

|

sqlserver2005

Dear all,

I have Sqlserver 2005 Express Edition only. and VS 2005. How to i create my .sdf file. and how to create tables in that file...

I am developing a SmartDevice Application. if any possible to access the Sql server 2000 DataBase without using .SDF file.

Note: in my system i have VS 2005, SQL SERVER 2000, SQL SERVER 2005 Express Edition. And aslo i installed MS-SQL SERVER 2005 Compact Edition Developer SDK[ENU].

In my Sql server 2005 Studio, there is no any sqlserver compact edition in the EngineType Combo.

what are the things i need to do.. to perfectly run my application with Data Base.

Thanks, Thanks for previous one also.

How can I manage SQL CE databases in SQL Server Management Studio?

Posted by Edward Tanguay on Stack Overflow See other posts from Stack Overflow or by Edward Tanguay
Published on 2009-02-23T10:55:59Z Indexed on 2010/04/12 11:13 UTC
Read the original article Hit count: 423

Filed under:

sql-server-ce

|

sql-server-management-stu

I created a SDF (SQL CE) database with Visual Studio 2008 (Add / New Item / Local Database).

Is it possible to edit this database with SQL Server Management Studio? I tried to attach it but it only offered .mdf and attaching a .sdf file results in "failed to retrieve data for this request".

If so, is it possible to create SDF files with Management Studio as well? Or are we stuck with the simple interface of the Visual Studio 2008 database manager?

Developer IT