I have a potential customer who has a server , and will be running a distributed application on each of the reps laptops.
There are about 15 reps, who will be running the application , disconnected, and then uploading data to the server
Sql express is not an option as Database sze is over 4 Gigs.

Does anybody know the licensing situaution in this case.... e.g. Do I need to purchase 15 server licenses at about $1800 each for each of the Reps laptops ?

I had a look at the MS pricing site but it gave no example of this situation

The problem is that we cannot depend on a connection to the internet...so that rules ES out as a connection is required I presume. Bottom line is a version of SQL Server will need to be on each laptop and I am wondering do they need a full server license (as in c $1800) rather than a Cal License (as in $180) for each laptop

Hi Gerard,



Your needs are another reason why we need SF tools to support for MySQL and/or VistaDB databases.



I have read the MS-SQL licensing stuff and it is designed to be complicated. Your approach of having the database server on each laptop is not very common and could be complicated, then you will need to do some sort of synchronization or replication to get new transactions.



I your case you need a light database engine for your off site laptops then handle the synchronization. MySQL would be just perfect for your scenario and if you prefer to work with MS-SQL in the main office, then VistaDB could be the solution since they claim to be 100% compatible with MS-SQL.



P.S.

I have not used VistaDB at all, just read their literature on their site. Still I believe MySQL could do just better since it is a proven database capable of handling millions of records.

Edhy Rijo