Hi,
We are looking into implementing SQL 2005 on one box and have SQL 2005 Reporting Services run on another box with its own replicated database. Mirrioring would not work in this scenario as the primary box has to be down for the secondary box to accept any incoming request.
My questions here is Microsoft website states that Transactional replication is supported for SQL 2005 Standard Edition, but I did watch some presentation on microsoft website that states that you need to have the Enterprise Edition to enable replication.
Can anyone tell me this is possible or not with the Standard Edition
Thanks,
SQL 2005 Standard Replication
noel 55
Transactional replication is fully supported in the Standard Edition. Your Standard Edition instance can be a Publisher, Distributor, and Subscriber.
There are different parts of replication that are enabled in different versions, however, so you have watched a presentation that was specific to a feature that is only available in Enterprise Edition. (Publishing from an Oracle instance, for example, requires a SQL Server Enterprise Edition instance as the Distributor.)
Phillip Garding
m_shane_tx
Merge Replication
Thanks,
Rod Landers
DiegoV
Rod,
SQL Server 2005 Workgroup Edition has full support for replication (both merge and transactional replication). SQL Server Express has limited support for replication and it can only be the subscriber in the replication.