CODEWITHSUNDEEP
sqlsql-serversql-server-express
nPcomp
nPcomp

Reputation: 9843

SQL Server Express replication

Is it possible to replicate or mirror one database from SQL Server Express to SQL Server ?

Upvotes: 0

Views: 2418

Answers (1)

RoMEoMusTDiE
RoMEoMusTDiE

Reputation: 4824

TechNet Link

SQL Server Express cannot serve as a Publisher or Distributor. However, merge replication allows changes to be replicated in both directions between a Publisher and Subscriber. SQL Server Express does not include SQL Server Agent, which is typically used to run replication agents.

but what you can do is impose a replication process, create a trigger that will insert or update your replicated server

Upvotes: 1

Related Questions