locked
mssql for linux (replication component not installed) RRS feed

  • Question

  • Hi

    I have MSSQL server  for linux 14.0.3023.8 on CentOS 7 (3.10.0-693.el7.x86_64)

    It is necessary to enable the replication of some tables on a similar server.

    SSMS reports that replication components are unavailable.

    -------

    sp_get_distributor reports

    installed: 0

    distribution server: NULL

    distribution db installed: 0

    is distribution publisher: 0

    --------------------

    sp_adddistributor reports: "Replication components are not installed on this server"

    ---------------------

    How do I enable or install replication components?

    Wednesday, April 4, 2018 10:10 AM

All replies

  • See Release notes for SQL Server 2017 on Linux => Unsupported features & Services => Replication; in current Version not available.

    Olaf Helper

    [ Blog] [ Xing] [ MVP]

    Wednesday, April 4, 2018 10:18 AM
  • I saw this document. But this is for the old version. Does anyone know when this feature will appear
    Wednesday, April 4, 2018 10:28 AM
  • Arkasha

    Perhaps this thread helps you

    https://social.msdn.microsoft.com/Forums/sqlserver/en-US/64c041f5-3822-408f-b072-99feb18a5fcc/replication-components-are-not-installed?forum=sqlreplication

    /*

    You need to run setup again and install the replication components. You can do this from the command line like this:

    setup.exe /q /Features=Replication /InstanceName=MSSQLSERVER /ACTION=INSTALL /IAcceptSQLServerLicenseTerms

    */


    Best Regards,Uri Dimant SQL Server MVP, http://sqlblog.com/blogs/uri_dimant/

    MS SQL optimization: MS SQL Development and Optimization
    MS SQL Consulting: Large scale of database and data cleansing
    Remote DBA Services: Improves MS SQL Database Performance
    SQL Server Integration Services: Business Intelligence

    Wednesday, April 4, 2018 10:52 AM
    Answerer
  • Looks like SQL Server vNext on Linux will have Replication. You can sign up to try this feature at https://sqlservervnexteap.azurewebsites.net/    <o:p></o:p>

    Under the "Are there any other specific features you will test and validate?", you can select [SQL Server on Linux: Replication] <o:p></o:p>

    Thursday, April 5, 2018 6:01 PM