SQL Server on Linux update

SQL Server on Linux

Since 2017 CU4, the SQL Server Agent is no longer a seperate package.

To enable SQL Server Agent:

either

  • sudo /opt/mssql/bin/mssql-conf set sqlagent.enabled true
  • sudo systemctl restart mssql-server

OR

  • During setup export MSSQL_AGENT_ENABLED=’true’

 

Replication Agents on Linux are in preview aka.ms/sqleap

 

  • Replication Agents are packaged in the server package.
  • Replication can be setup across Windows/Linux and use AD Auth
  • Docker support is currently being tested and will come soon.
  • Replication Agents on Linux can be managed via SSMS on Windows and normally tools as mainly done via stored procs
  • Snapshot,Transactional and Merge Replication are supported
  • Publisher,Distribtutor or Subscriber can be on Linux
  • SQLOps Studio can be used to configure snapshot replication via stored procs

 

 

Advertisements


Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s