December 2, 2018 at 10:19 pm
Hello,
Is there a good inexpensive way to scale out an existing primary replica on SQL Server 2016 Enterprise ( in addition to an existing single secondary replica) for reporting purposes? We were thinking about replication from SQL Server to MySQL/PostgreSQL via 3rd party tool, as all other ways such as an additional Secondary Replicas(AlwaysOn), LogShipping, Transactional Replication are quite expensive for an Enterprise version.
Thank you
December 9, 2018 at 9:13 pm
Anyone? Anything?
December 10, 2018 at 5:11 am
You could always use Standard edition for subscriber which is not that expensive for reporting and use Transactional replication.
-Roy
December 11, 2018 at 9:22 pm
Say, I have 10 subscribers for the same article. Will I get a performance hit on a publisher?
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy