I have done so for SQL Server, now I was trying to do it SQL Server Compact.
I am unable to make a connection string in SQL Server Compact which has the provision for providing ip/server.
Can I access sdf (SQL Server Compact database file) kept at some other computer on the same network?
-
5SQL Server CE is not intended for network use - it's a local-machine only "database" (or cache) - not a network-ready database system.marc_s– marc_s2012-12-07 07:39:24 +00:00Commented Dec 7, 2012 at 7:39
-
1it does not seem logical that i can't access the sdf, such a handicap if that is the case.Amber– Amber2012-12-07 07:43:20 +00:00Commented Dec 7, 2012 at 7:43
-
1SQL Server Compact is just not designed to be used in a network. It's designed as a local-only cache/database store. It was a design decision made by its authors ... if you need something that works for multiple users in a network - use the real SQL Server (Express or any other edition).marc_s– marc_s2012-12-07 07:45:51 +00:00Commented Dec 7, 2012 at 7:45
-
1how are we supposed to extract info from the sdf then? I mean i've used the software to deploy at some place. Obviously i would not want to go there everytime i want some info.Amber– Amber2012-12-07 07:58:21 +00:00Commented Dec 7, 2012 at 7:58
-
You can use something like the Sync Framework to get the data back to an SQL Server.PeterJ– PeterJ2012-12-07 08:01:16 +00:00Commented Dec 7, 2012 at 8:01
|
Show 4 more comments
2 Answers
Try Replicating Data to a remote server. http://msdn.microsoft.com/en-us/library/ms152568(v=sql.105).aspx
1 Comment
Alexei Levenkov
Added new community wiki answer covering links provided by Amber and also merged comments into answer. Feel free to vote to delete from review.
SQL Server Compact is just not designed to be used in a network. It's designed as a local-only cache/database store. It was a design decision made by its authors ... if you need something that works for multiple users in a network - use the real SQL Server (Express or any other edition) (by marc_s
It is also considered bad idea to expose SQL server to network - you may want to redesign your application to have service exposing limited functionality to users and calling DB (in this case you can use local SQL compact, but still consider other editions that are more appropriate to general data storage).
If SQL Compact is requirement - replicate data to local file - MSDN:Replicating Data to SQL Server Compact.
For more information on Sql Compact connection strings - Connecting C# to SQL Server Compact database