Read-Only Replica between a Standard Edition and Enteprise Edition

VivekD 122 Reputation points
2021-03-08T17:30:20.81+00:00

We have 2 servers, one with standard edition and one enterprise edition of SQL Server.

We would like a couple of databases in the standard edition be replicated (for read-only purposes) into the 2nd server with the enterprise edition.

Given the current licenses, what's the best method to achieve that especially if we want it to be a real-time or near-real time replica?

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,486 questions
0 comments No comments
{count} votes

1 additional answer

Sort by: Most helpful
  1. AmeliaGu-MSFT 13,961 Reputation points Microsoft Vendor
    2021-03-09T05:50:09.077+00:00

    Hi VivekD-8637,

    In addition, by default, Subscribers to transactional publications should be treated as read-only, because changes are not propagated back to the Publisher. However, transactional replication does offer options that allow updates at the Subscriber.
    For log shipping, the secondary database may be in either the RECOVERING state or the STANDBY state, which leaves the database available for limited read-only access. But database can’t be read when you’re refreshing data, you must kick out any users as Erland mentioned.
    Please refer to Transactional Replication and Log Shipping which might help.

    Best Regards,
    Amelia


    If the answer is helpful, please click "Accept Answer" and upvote it.
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread

    0 comments No comments