Sounds like a good question for the sql server lists: www.swynk.com
SQL7 and MSDE on the laptops might be workable. Im not familiar with 2 way
replication scheme's so the best place to ask would be sql7 list on
ww.swynk.com
hth,
Steve
> Here is one for you all.
>
> I am running a new site and the database is currently Access97. The
> conditions any prospective database must meet are as follows.
>
> 1) Fast (already 1/4 million records and growing fast, probably into the
> 10's of millions)
> 2) Replicable. Sales staff in the field (World Wide) need to enter
> information into a copy of the database on their laptops then dial into
> their regional office and synchronise their data with our master, this
must
> be 2 way replication not just upload.
> 3) Internet Replication is desirable so we can synchronise the data with
the
> web server without needing to upload 50-200Mb files via FTP to synchronise
> 20kb worth of changes.
>
> The web server is a Dell, dual PIII 600, 256Mb Ram, 32Gb Raid5 HDD,
> redundant PSU etc... so the server is fast, the current access based
system
> runs queries in under 250ms. We are thinking of upgrading to MS SQL
Server,
> but if there is a better option I want to know about it.
>
> Any suggestions?
>
> --
> James Smith
> [EMAIL PROTECTED]
>
> I love deadlines.
> I especially like the whooshing sound they make as they go flying by.
>
>
>
> --------------------------------------------------------------------------
----
> Archives: http://www.eGroups.com/list/cf-talk
> To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
>
------------------------------------------------------------------------------
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
