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
-
1How many entities do you need to replicate? How frequently do you need them replicated?– J.D.Commented Nov 21, 2021 at 14:25
-
Can you provide more information about what you're trying to achieve with replication and why?– HandyDCommented Nov 22, 2021 at 0:49
Add a comment
|
2 Answers
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.
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.
answered Nov 24, 2021 at 13:06
David Browne - MicrosoftDavid Browne - Microsoft
47.7k3 gold badges51 silver badges101 bronze badges