Link to home
Start Free TrialLog in
Avatar of itnifl
itniflFlag for Norway

asked on

SQL Server Express 2014 Master / Slave database replication

I went through this:
https://msdn.microsoft.com/en-us/library/cc645993(v=sql.120).aspx

It seems that SQL Server Express 2014 does not have the option for any type of replication other than as a client/subscriber and not the option for database mirroring other than with the role as a witness.

So are there any other possible solutions or third party products out there for usage with IIS that can handle master / slave replication between databases on SQL Server Express 2014  that might be considered, or is this a dead end that is best fixed by upgrading the version of SQL server that is in use?
ASKER CERTIFIED SOLUTION
Avatar of Randy Poole
Randy Poole
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of itnifl

ASKER

The functionality I actually need is database mirroring in high safety mode with a witness server. For that I need two SQL Server 201x Standard for the databases and one SQL Server 201x Express as a Witness to be able to handle automatic fail over. But I guess that if the witness fails, then automatic fail over also fails.

Unless there are other ways...
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of itnifl

ASKER

Thanks for confirming!