SQL Express or SQL Compact
Posted on 2011-05-05
I am use to at work using SQL Enterprise.. I have been asked to create a small project for a volunteer program for a yearly course they hold that only has maybe 40 participants & about 12 staff members..
So being of little cash, SQL Enterprise is out of the question.. But they would like it to be on the internet, so the staff can work on it from their homes. But can be pulled off & stand-alone when need be.. (the course itself is run in the woodlands where there is no hookup & you have to climb to a mountain peak to pick up cell phone signals..).. Then of course when done with the course, the data would need to be uploaded to the internet again
From reading Compact is for mobile devices and to sync up, We are designing for an internet and laptops (which will need to work off-line on occasion).. So maybe Express is what I want??
But I do want to sort of sync up.. I mean when the user goes off line they need at least some of the database on the internet to download to their database on a stand-alone version on their laptop. Then when they get back on-line, they need to upload modified records back to the internet database..
I do hope I can go with SQL Express, or one of you can point me on the right track on how to use Compact 3.5.. Because SQL Express has queries and is very similar to me to working with SQL Enterprise, especially when using in Visual studio (although I know deployment is a little more quirky, I am fine with how to create a msi package..) I can find little to direct me on how to code using the Compact 3.5.. How to modify records with the Database programically, let alone how to transfer data from one Database to another.. I got stuck just trying to move a talbe with two image fields from SQL Enterprise to the Compact.. I read that I could just put them in the VS Server Explorer and copy and paste between the two, this worked but for the image fields, and is of no use when building a contained package for users even if I was successful..