I've been asked to set up SQL Server 2016 replication between a development PC running Windows 10 Home and Windows Server 2012 R2. Both run developer versions of SQL Server 2016.
I have found this tutorial: Replication Tutorials SQL Server 2016 and later
This is when I realised that the Windows 10 Home edition does not allow you to create extra users and groups, and in order to do so I would need to spend another £120 to upgrade to Windows 10 Pro.
I've never set up server replication at all, my question is:
- Is it possible to setup replication between those operating systems and SQL Servers Dev Editions?
I thought I ask before spending the money just in case it is not possible or I will hit ridiculous amount of problems doing it.
I tried finding anything on that online, to no avail. The Editions and Supported Features for SQL Server 2016 do not mention SQL Server 2016 Developer Edition and the only version from that list that supports Windows 10 is SQL Server 2016 Standard.
Best Answer
https://msdn.microsoft.com/en-GB/library/ms143506.aspx shows SQL 2016 Dev as supported on Win10 Home, and I don't know of any explicit feature limitations--though you are right in general that you're limited to what the OS supports.
Have you tried to set up replication using the built-in service logins? I believe the instructions around adding Windows logins are for security best practice, which may not be an issue for a dev environment.