ProfReynolds
Programmer
If I have done my research correctly, this should work, but I'm hoping to get some confirmation.
Essentially, I would like to set up a SQL Server Standard instance as a Distributor\Subscriber in a transactional replication model. It would be running on a full Server 2003 system in one office.
A SQL Server Workgroup edition would be the publisher. It would run on an SBS system in a separate office.
It is my understanding that since the distribution agent will not run on WorkGroup servers, but that if it resides with the Standard edition server, the WorkGroup instance will be adequately replicated.
I would be interested in your thoughts. Thanks!
Essentially, I would like to set up a SQL Server Standard instance as a Distributor\Subscriber in a transactional replication model. It would be running on a full Server 2003 system in one office.
A SQL Server Workgroup edition would be the publisher. It would run on an SBS system in a separate office.
It is my understanding that since the distribution agent will not run on WorkGroup servers, but that if it resides with the Standard edition server, the WorkGroup instance will be adequately replicated.
I would be interested in your thoughts. Thanks!
