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)?
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It only takes a minute to sign up.
Sign up to join this communityCan 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