Can I define transactional replication while the Publisher and Distributor are both Enterprise Edition and the Subscriber is Standard Edition?

What do I need to consider in case it is possible (given I already know about partitioned tables)?


Yes, you can replicate from Enterprise edition to Standard edition.

The only caveat is Peer-to-Peer Replication requires all nodes to be Enterprise Edition, and Web and Express editions are Subscriber only.

Features Supported by the Editions of SQL Server - Replication

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.