Minimum Setup Requirements for SQL 2005 Replication.

What are the minimum setup requirements to support the following.
2 Remote Laptops running SQL Server 2005 Express databases with the ability
to synchronize with each other. Also they should be able to synch with a
server hosting a SQL Database whci is accessible from 2 other Desktop PCs.
What are the SQL CAL Licensing issues that would apply to this scenario.
Regards
Unfortunately SQL Server Express can only be a subscriber to all types of
replication. All subscriptions must be created through RMO or replication
stored procedures.
Regarding your desktop pc's - If they are running workgroup edition they can
have up to 25 merge subscribers, but 5 transactional subscribers. In regards
to licensing anything which accesses the desktop must have a license, which
can be a CAL or a server per processor license (which will not make a whole
lot of sense).
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Stuart Lowe" <StuartLowe@.discussions.microsoft.com> wrote in message
news:6C1471E6-61F1-4BF2-AAA8-16E67A29A967@.microsoft.com...
> What are the minimum setup requirements to support the following.
> 2 Remote Laptops running SQL Server 2005 Express databases with the
> ability
> to synchronize with each other. Also they should be able to synch with a
> server hosting a SQL Database whci is accessible from 2 other Desktop PCs.
> What are the SQL CAL Licensing issues that would apply to this scenario.
> Regards
sql

Migration Access - Sql Server

Hi,
I am new to Sql Server.
I have a development done in MS Access, it is running on a server, splitted BE / FE and replications for we have 5 laptops that run and update the DB offline and then sync to the LAN, when they return to headquaters.
I want to migrate this to them syncing through the internet to a main BE, but I still want them to have an offline version for them to work during the day.
Can this me done in Sql Server? Can I easily re-use my Access development ?
The BE would be in a 3rds party ISP, what would my requirements be?
Cheers
Pata.
Pata,
to be honest I haven't seen the acronyms BE or FE before, but the main
principle is straightforward enough.
You could upgrade all your access instances entirely to SQL Server or you
could use heterogenous replication and have a central publisher at HO which
is SQL Server with remote subscribers which are access. Either way, we are
talking about merge replication, with pull subscriptions. As this is an
internet project, you might find this link useful:
http://support.microsoft.com/?id=321822.
Please can you post back with the BE/FE descriptions and I might then expand
on things a bit.
HTH,
Paul Ibison