Share via

Mirror sync between two servers

OptimalPyme 1 Reputation point
2021-02-09T16:02:28.033+00:00

Hi to everyone,

We are going to deploy a mirror sync between two servers with Microsoft SQL Server 2019. Before this, we want to know whether the entire database is synchronised in the mirror or whether we have the option to choose individually which tables we want to synchronise.

Thanks in advance.

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,058 questions
SQL Server Migration Assistant
SQL Server Migration Assistant
A Microsoft tool designed to automate database migration to SQL Server from Access, DB2, MySQL, Oracle, and SAP ASE.
503 questions

3 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. tibor_karaszi@hotmail.com 4,306 Reputation points
    2021-02-09T17:22:59.597+00:00

    There's no feature named "mirror sync" in SQL Server. If you say exactly the name of the feature you are about to use, then we can answer. Examples of features that you might refer to:

    Always On Availability Groups
    Database Mirroring
    Replication
    Transactional
    Merge
    Snapshot

    0 comments
  2. CathyJi-MSFT 21,106 Reputation points Microsoft Vendor
    2021-02-10T03:36:29.69+00:00

    Hi @OptimalPyme ,

    > we want to know whether the entire database is synchronised in the mirror or whether we have the option to choose individually which tables we want to synchronise.

    If you mean database mirroring, it is a database level HA. You can’t choose individually table to sync. Please refer to Database Mirroring (SQL Server) and Configure database mirroring.

    If you want to sync table, suggest you use transaction replication. Please refer to Transactional Replication.

    By the way, if you want to sync entire database, you can also use Always ON Availability Group.

    Suggest you read the blog Difference Between Always On Failover Cluster, Database Mirroring, Always On Availability Group, Replication and Log Shipping.

    If the response is helpful, please click "Accept Answer" and upvote it, thank you.

    0 comments
  3. Alex Bykovskyi 1,831 Reputation points
    2021-02-14T11:30:22.883+00:00

    Hi,

    As mentioned, there are various ways to achieve HA for the SQL Server. Depending on your goals and SQL Server editions you can choose different technologies. As for Database mirroring might help: https://learn.microsoft.com/en-us/sql/database-engine/database-mirroring/setting-up-database-mirroring-sql-server?view=sql-server-ver15

    In addition, the following article might be helpful to understand the difference between Basic Availability Groups and SQL FCI:
    https://www.starwindsoftware.com/resource-library/sql-server-failover-cluster-instance-vs-basic-availability-group/

    Cheers,

    Alex Bykovskyi

    StarWind Software

    Note: Posts are provided “AS IS” without warranty of any kind, either expressed or implied, including but not limited to the implied warranties of merchantability and/or fitness for a particular purpose.

    0 comments