Tjyylli

Stars Make Stars

How can you insert a "times/divide" symbol similar to the "plus/minus" (±) one?

Why is "Captain Marvel" translated as male in Portugal?

The following signatures were invalid: EXPKEYSIG 1397BC53640DB551

How can players take actions together that are impossible otherwise?

Are my PIs rude or am I just being too sensitive?

Complexity of many constant time steps with occasional logarithmic steps

Writing Thesis: Copying from published papers

How can I make names more distinctive without making them longer?

If A makes B more likely then B makes A more likely"

What computer would be fastest for Mathematica Home Edition?

Jazz greats knew nothing of modes. Why are they used to improvise on standards?

How to say 'striped' in Latin

Need a suitable toxic chemical for a murder plot in my novel

What would be Julian Assange's expected punishment, on the current English criminal law?

How to set letter above or below the symbol?

Typsetting diagram chases (with TikZ?)

Statistical model of ligand substitution

Cauchy Sequence Characterized only By Directly Neighbouring Sequence Members

Why don't the Weasley twins use magic outside of school if the Trace can only find the location of spells cast?

When is phishing education going too far?

Simulating Exploding Dice

Autumning in love

Single author papers against my advisor's will?

best way to run sql server management studio on linux

.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty{ margin-bottom:0;
}

3

I'm using ubuntu 18.04.2 on my desktop and running sql server 2017 from docker.

I want to use sql server management studio to manage the server.

SO far now, I have a windows 7 enterprise with with ssms 17.9.1 and it works ok

It's really annoying having to boot a whole windows enterprise just for a single app, so I wanted to know if there's some better way to run it. A lighter or better integrated alternative.

that version of ssms doesn't seem to work with wine.

sql-server ssms linux virtualisation

share|improve this question

asked yesterday

opensasopensas

15414

add a comment | 

3

I'm using ubuntu 18.04.2 on my desktop and running sql server 2017 from docker.

I want to use sql server management studio to manage the server.

SO far now, I have a windows 7 enterprise with with ssms 17.9.1 and it works ok

It's really annoying having to boot a whole windows enterprise just for a single app, so I wanted to know if there's some better way to run it. A lighter or better integrated alternative.

that version of ssms doesn't seem to work with wine.

sql-server ssms linux virtualisation

share|improve this question

asked yesterday

opensasopensas

15414

add a comment | 

I'm using ubuntu 18.04.2 on my desktop and running sql server 2017 from docker.

I want to use sql server management studio to manage the server.

SO far now, I have a windows 7 enterprise with with ssms 17.9.1 and it works ok

It's really annoying having to boot a whole windows enterprise just for a single app, so I wanted to know if there's some better way to run it. A lighter or better integrated alternative.

that version of ssms doesn't seem to work with wine.

sql-server ssms linux virtualisation

share|improve this question

asked yesterday

opensasopensas

15414

share|improve this question

asked yesterday

opensasopensas

15414

share|improve this question

asked yesterday

opensasopensas

15414

asked yesterday

opensasopensas

15414

asked yesterday

opensasopensas

15414

1 Answer
1

active

oldest

votes

6

You can't run Sql Server Management Studio on Linux. But there is an alternative that is provided by Microsoft called Azure Data Studio. Not all features are available in Azure Data Studio that are available in Sql Server Management Studio - the main difference is that Azure Data Studio is missing a lot of the wizards that are available in SSMS.

Use Azure Data Studio if you:

• Need to run on macOS or Linux


• Are connecting to a SQL Server 2019 big data cluster


• Spend most of your time editing or executing queries


• Need the ability to quickly chart and visualize result sets


• Can execute most administrative tasks via the integrated terminal using sqlcmd or Powershell


• Have minimal need for wizard experiences


• Do not need to do deep administrative configuration

Use SQL Server Management Studio if you:

• Spend most of your time on database administration tasks


• Are doing deep administrative configuration


• Are doing security management, including user management, vulnerability assessment, and configuration of security features


• Make use of the Reports for SQL Server Query Store


• Need to make use of performance tuning advisors and dashboards


• Are doing import/export of DACPACs


• Need access to Registered Servers and want to control SQL Server services on Windows

The snippet above is taken from Sql Server Blog and provides a comparison of features.

If you are happy to pay for a tool, then take a look at Aqua Data Studio and SQL Maestro which have quite a lot of features and a wide range of support for other database platforms.

share|improve this answer

edited yesterday

answered yesterday

Mr.BrownstoneMr.Brownstone

10.1k32546

• 
  
  
  

  
  2
  

  
  
  
  
  
  

  
  
  Adding that ADS also includes many features not available in SSMS as called out in the referenced blog link.
  
  – Dan Guzman
  yesterday
  

  
  
  
  

add a comment | 

Your Answer

StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "182"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);

StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});

function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: false,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: null,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});


}
});

draft saved

draft discarded

Sign up or log in

StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});

Sign up using Google

Sign up using Facebook

Sign up using Email and Password

Post as a guest

Name

Email

Required, but never shown

StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fdba.stackexchange.com%2fquestions%2f234713%2fbest-way-to-run-sql-server-management-studio-on-linux%23new-answer', 'question_page');
}
);

Post as a guest

Name

Email

Required, but never shown

6

You can't run Sql Server Management Studio on Linux. But there is an alternative that is provided by Microsoft called Azure Data Studio. Not all features are available in Azure Data Studio that are available in Sql Server Management Studio - the main difference is that Azure Data Studio is missing a lot of the wizards that are available in SSMS.

Use Azure Data Studio if you:

• Need to run on macOS or Linux


• Are connecting to a SQL Server 2019 big data cluster


• Spend most of your time editing or executing queries


• Need the ability to quickly chart and visualize result sets


• Can execute most administrative tasks via the integrated terminal using sqlcmd or Powershell


• Have minimal need for wizard experiences


• Do not need to do deep administrative configuration

Use SQL Server Management Studio if you:

• Spend most of your time on database administration tasks


• Are doing deep administrative configuration


• Are doing security management, including user management, vulnerability assessment, and configuration of security features


• Make use of the Reports for SQL Server Query Store


• Need to make use of performance tuning advisors and dashboards


• Are doing import/export of DACPACs


• Need access to Registered Servers and want to control SQL Server services on Windows

The snippet above is taken from Sql Server Blog and provides a comparison of features.

If you are happy to pay for a tool, then take a look at Aqua Data Studio and SQL Maestro which have quite a lot of features and a wide range of support for other database platforms.

share|improve this answer

edited yesterday

answered yesterday

Mr.BrownstoneMr.Brownstone

10.1k32546

• 
  
  
  

  
  2
  

  
  
  
  
  
  

  
  
  Adding that ADS also includes many features not available in SSMS as called out in the referenced blog link.
  
  – Dan Guzman
  yesterday
  

  
  
  
  

add a comment | 

6

You can't run Sql Server Management Studio on Linux. But there is an alternative that is provided by Microsoft called Azure Data Studio. Not all features are available in Azure Data Studio that are available in Sql Server Management Studio - the main difference is that Azure Data Studio is missing a lot of the wizards that are available in SSMS.

Use Azure Data Studio if you:

• Need to run on macOS or Linux


• Are connecting to a SQL Server 2019 big data cluster


• Spend most of your time editing or executing queries


• Need the ability to quickly chart and visualize result sets


• Can execute most administrative tasks via the integrated terminal using sqlcmd or Powershell


• Have minimal need for wizard experiences


• Do not need to do deep administrative configuration

Use SQL Server Management Studio if you:

• Spend most of your time on database administration tasks


• Are doing deep administrative configuration


• Are doing security management, including user management, vulnerability assessment, and configuration of security features


• Make use of the Reports for SQL Server Query Store


• Need to make use of performance tuning advisors and dashboards


• Are doing import/export of DACPACs


• Need access to Registered Servers and want to control SQL Server services on Windows

The snippet above is taken from Sql Server Blog and provides a comparison of features.

If you are happy to pay for a tool, then take a look at Aqua Data Studio and SQL Maestro which have quite a lot of features and a wide range of support for other database platforms.

share|improve this answer

edited yesterday

answered yesterday

Mr.BrownstoneMr.Brownstone

10.1k32546

• 
  
  
  

  
  2
  

  
  
  
  
  
  

  
  
  Adding that ADS also includes many features not available in SSMS as called out in the referenced blog link.
  
  – Dan Guzman
  yesterday
  

  
  
  
  

add a comment | 

You can't run Sql Server Management Studio on Linux. But there is an alternative that is provided by Microsoft called Azure Data Studio. Not all features are available in Azure Data Studio that are available in Sql Server Management Studio - the main difference is that Azure Data Studio is missing a lot of the wizards that are available in SSMS.

Use Azure Data Studio if you:

• Need to run on macOS or Linux


• Are connecting to a SQL Server 2019 big data cluster


• Spend most of your time editing or executing queries


• Need the ability to quickly chart and visualize result sets


• Can execute most administrative tasks via the integrated terminal using sqlcmd or Powershell


• Have minimal need for wizard experiences


• Do not need to do deep administrative configuration

Use SQL Server Management Studio if you:

• Spend most of your time on database administration tasks


• Are doing deep administrative configuration


• Are doing security management, including user management, vulnerability assessment, and configuration of security features


• Make use of the Reports for SQL Server Query Store


• Need to make use of performance tuning advisors and dashboards


• Are doing import/export of DACPACs


• Need access to Registered Servers and want to control SQL Server services on Windows

The snippet above is taken from Sql Server Blog and provides a comparison of features.

If you are happy to pay for a tool, then take a look at Aqua Data Studio and SQL Maestro which have quite a lot of features and a wide range of support for other database platforms.

share|improve this answer

edited yesterday

answered yesterday

Mr.BrownstoneMr.Brownstone

10.1k32546

share|improve this answer

edited yesterday

answered yesterday

Mr.BrownstoneMr.Brownstone

10.1k32546

answered yesterday

Mr.BrownstoneMr.Brownstone

10.1k32546

answered yesterday

Mr.BrownstoneMr.Brownstone

10.1k32546