February 16, 2012 at 3:23 am
Hi
This is the requirement...
There is no need for the client to be aware of underlying database, silent install. No need of seperate installation, everything should cover in one installation.
The data should be protected, secured (Password protected, encrypted), there should not be any limit in data storage. Licensing one time cost.
also standalone application....
can be installed in server with networked clients
We canot use SQL Express and Compact because of storage limitation
Thank you
With regards
Dilip
February 16, 2012 at 3:55 am
Is this supposed to be a desktop application?
SQL Server 2008 R2 Express Edition supports databases up to 10 GB in size. I would be very concerned about running applications that require more than 10 GB of data on a desktop/laptop computer. Did you take this into account?
However, SQL Server (any edition) can be installed seamlessly using the command line and the setup can be embedded in your app setup easily.
-- Gianluca Sartori
February 16, 2012 at 3:59 am
dilipd006 (2/16/2012)
The data should be protected, secured (Password protected, encrypted)
You can use Transparent Data Encryption for this.
there should not be any limit in data storage.
I think I covered this one in my previous post.
Licensing one time cost.
Microsoft SQL Server Licensing
-- Gianluca Sartori
February 16, 2012 at 11:47 pm
thanks for the reply
There will be two versions of application one for server and other as client, both needs sql server dataabase, and what type of licencing should I consider. The link you given
i had already read that but i am confused with this licensing issue.
Client requirement is there should not be any restrictions in data storage.The software users should not be bothered about the licencing or restrictions.
Client can use software in offline mode and online mode. when they are offline all the data will be stored in their local DB and will be uploaded to the server after some day may be bulkloading. Which edition will support this functionality.
One issue is id generated by different clients...when all of them upload the data to the server it willl generate error because of id duplication...this can be solved using GUID..but performance issue will be there
February 17, 2012 at 2:54 am
I think that your best option is installing Enterprise or Standard edition on the server and then set up merge replication with clients.
Client machines will run Express edition (10 GB of data is quite a lot for a desktop/laptop) and could work on a data partition.
Merge replication will take care of synchronizing data and, to some extent, merge conflicts.
-- Gianluca Sartori
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply