1

We are using SQL express that does not support DB replication to other servers.

1- is there any way/free tool that enable us to perform any type of replication?

2- do you have any idea to share the database to other servers rather than replication?

2
  • 1
    How many entities do you need to replicate? How frequently do you need them replicated?
    – J.D.
    Nov 21, 2021 at 14:25
  • Can you provide more information about what you're trying to achieve with replication and why?
    – HandyD
    Nov 22, 2021 at 0:49

2 Answers 2

2

I saw in some installations home-written SQL scripts that mimic SQL transaction log shipping. If you google, you will get plethora of resources. I.e. how to achieve t-log shipping with T-SQL scripts. For example: LINK

It all boils down to backing up your SOURCE server to shared folder where your TARGET servers have access and the TARGET servers restore these backups from the share.

Please bear in mind you cannot schedule this behaviour with SQL server agent in SQL express (as SQL express does not have SQL agent), you'll need to use OS scheduler for backup and restore.

1

SQL Server Express supports Merge Replciation where changes made at subscribers are synchronized to the publisher and then out to other subscribers in a hub-and-spoke topology. The "hub" instance is the only "publisher" and would need to be SQL Server Standard Edition or higher.

The other option is to turn on Change Tracking and write ETL jobs to extract the changed rows and apply them to another database.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.