CODEWITHSUNDEEP
sql-servermirroringreadonlylog-shipping
user2616409
user2616409

Reputation: 1

How mirror two SQL Servers Express with different versions using the Log Shipping method?

I have a desktop application accessing a SQL Server database. I have a web application, running on a remote computer (Amazon EC2).

I tried mirroring between two SQL Servers using Log Shipping method, but due the different SQL Server versions, the database does not restore in STANDBY mode, even if the Amazon EC2 SQL Server version is newer than local SQL Server.

For the records: the online application may access the database in read-only mode.

I'm asking for some help with ideas to solve my issue. Thanks in advance.

Upvotes: 0

Views: 367

Answers (1)

Alfred M
Alfred M

Reputation: 46

You might want to use transnational replication to transfer data. If there is possibility update different rows in both DB at the same time, you can use merge replication.

Upvotes: 1

Related Questions