Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Replication from one SQL Server Express to another

Tags:

I have one SQL Server Express instance with a pretty normal well formed database. I need to have the data continuously replicated to a SQL Server Express instance on another server.

Now, I know that SQL Server Express does not include the Publisher part of built-in replication, so I'm looking for alternative solutions. I do not want to upgrade any of the databases.

Naturally, I could make my own replication with guids, timestamps etc. and transfer the data using my own coding(as suggested in SQL Server Express database replication/synchronization), but I would want to avoid all that work, especially seeing that the replication is really very basic.

Perhaps a generic trigger added to each table? Perhaps some kind of database job?

Any suggestions?