Hot answers tagged replication
It is in the known limitations: Currently replication works only with the InnoDB storage engine. Any writes to tables of other types, including system (mysql.*) tables are not replicated (this limitation excludes DDL statements such as CREATE USER, which implicitly modify the mysql.* tables — those are replicated). There is however experimental support ...
I'm using log shipping extensively with SQL Server Standard edition. Replication also works fine with Standard edition. (Here are the SQL versions that support log shipping out of the box. Here is a less extensive chart with how the versions of SQL Server support replication.) Since you're using Express, you don't have access to SQL Server Agent, which ...
You would use it when you want complete control over the timing of replication, e.g. once a day at midnight, as opposed to continuous replication.
Only top voted, non community-wiki answers of a minimum length are eligible