i used to open sdf (sqlCE) files with visual-studio ?? or sql-server ??
i really don't remember.
now i can't open this sdf file
with what program do i need to open it ?
+3
A:
It's a SQL Compact database. You need to define what you mean by "Open". You can open it via code with the SqlCeConnection so you can write your own tool/app to access it.
Visual Studio can also open the files directly if was created with the right version of SQL Compact.
There are also some third-party tools for manipulating them.
ctacke
2010-03-03 21:32:58
thank's for the help, when i write Open i mean - to see tables andto write query's (i thing that i use to open with the visual-studio)but now i cant
Gold
2010-03-03 21:43:07
A:
In addition to the methods described by @ctacke, you can also open SQL Server Compact Edition databases with SQL Server Management Studio. You'll need SQL Server 2008 to open SQL CE 3.5 databases.
Phil Ross
2010-03-03 21:40:55