We have a C/S application, but our Client DB will not be
connected with the server fulltime. In this case what kind
of SQL server (LITE) we can use on our client machines to
have synchronized the Data Bases with the serve master
DataBase using a dial-up connection one hour per day or

Take a look at the Desktop Edition (MSDE). It may suite your needs and is
basically free:

http://www.microsoft.com/sql/msde/default.asp

--

Andrew J. Kelly
SQL Server MVP


[quoted text, click to view]

Murdockio,

Depends on how much of data you want to copy from the production database.As
Andrew mentioned, you can go with msde but if you want your local database
to be a mirror of production, then msde may not suffice as it has a limit of
2GB.Also, some of the features of other editions are not supported in
msde.Your other options would be to go with Developer edition ( if you are
not going to use this local data for production purposes) or even personal
edition(if you can cope with the limited concurrent connections ).Developer
edition rate will be reduced to $49 by August
03(http://www.microsoft.com/sql/howtobuy/development.asp)

--
Dinesh.
SQL Server FAQ at
http://www.tkdinesh.com

[quoted text, click to view]