Does SQL Server 2005 Express support Web/Internet Replication to other SQL Server Express Cl

HI

Q1: Does Sql Server 2005 Express support Web/Internet to other SQL Server 2005 Express Clients or does it have to Synch across the internet to a fully installed setup SQL Server 2005 with IIS?

Q2: Does SQL Server 2005 Express support Direct Replication between other SQL Server 2005 Express clients?

Regards

Shabby wrote:

HI

Q1: Does Sql Server 2005 Express support Web/Internet to other SQL Server 2005 Express Clients or does it have to Synch across the internet to a fully installed setup SQL Server 2005 with IIS?

You have to sync to a SS2005 with IIS. Replication doesn't support sync between sql express.

Shabby wrote:

Q2: Does SQL Server 2005 Express support Direct Replication between other SQL Server 2005 Express clients?

Regards

No Sql 2005 express cannot sync with sql 2005 express directly.

|||

SQL Server 2005 Express Edition supports being a replication subscriber only. See http://msdn2.microsoft.com/en-us/library/ms165700.aspx The publisher and distributor must be higher SKUs of SQL Server 2005. i.e. Enterprise, Standard, Workgroup. As for synching via IIS over the internet with merge replication, this is supported by the SQL Server 2005 Express client.

Hope this helps,

Tom

This posting is provided "AS IS" with no warranties, and confers no rights.

|||

Express edition can only be used as a subscriber, including direct SQL replication or web sync. Please take a look at this link for replication features supported by various editions (http://msdn2.microsoft.com/en-us/library/ms143761.aspx).

Thanks,

Peng

|||

Peng Song wrote:

Express edition can only be used as a subscriber, including direct SQL replication or web sync. Please take a look at this link for replication features supported by various editions (http://msdn2.microsoft.com/en-us/library/ms143761.aspx).

Thanks,

Peng

does the client (subscriber) running on sql server express has to have IIS or only the publishing pc? thanks