best way to run sql server management studio on linux Announcing the arrival of Valued Associate #679: Cesar Manara Planned maintenance scheduled April 23, 2019 at 23:30 UTC (7:30pm US/Eastern)Why should I use Visual Studio 2010 over SSMS for my database development?Quickly clone a database in SQL Server Management StudioSQL Server Management studio slow connection or timeout when using Windows AuthenticationCan't create database in SQL Server Express 2005Prevent SQL Server Management Studio changing destination DB on restoreSSMS - Is it possible to pass additional connection parameters via Command Line?Is there a developer edition of Microsoft SQL Server 2017 for Linux?SQL Management Studio 2012 not loadingWhat are the notable difference between versions of SSMS?How to prevent SQL files opening new instances of SSMS 17.9.1?
.bashrc alias for a command with fixed second parameter
How to make an animal which can only breed for a certain number of generations?
Why is there so little support for joining EFTA in the British parliament?
calculator's angle answer for trig ratios that can work in more than 1 quadrant on the unit circle
Improvising over quartal voicings
Keep at all times, the minus sign above aligned with minus sign below
How to show a density matrix is in a pure/mixed state?
How can I prevent/balance waiting and turtling as a response to cooldown mechanics
Changing order of draw operation in PGFPlots
Understanding piped commands in GNU/Linux
geoserver.catalog.FailedRequestError: Tried to make a GET request to http://localhost:8080/geoserver/workspaces.xml but got a 404 status code
Why are current probes so expensive?
How can I introduce the names of fantasy creatures to the reader?
malloc in main() or malloc in another function: allocating memory for a struct and its members
Can I cut the hair of a conjured korred with a blade made of precious material to harvest that material from the korred?
Is there a canonical “inverse” of Abelianization?
Why not use the yoke to control yaw, as well as pitch and roll?
Why complex landing gears are used instead of simple, reliable and light weight muscle wire or shape memory alloys?
Was the pager message from Nick Fury to Captain Marvel unnecessary?
Does the main washing effect of soap come from foam?
Why can't fire hurt Daenerys but it did to Jon Snow in season 1?
Why do C and C++ allow the expression (int) + 4*5?
Pointing to problems without suggesting solutions
What helicopter has the most rotor blades?
best way to run sql server management studio on linux
Announcing the arrival of Valued Associate #679: Cesar Manara
Planned maintenance scheduled April 23, 2019 at 23:30 UTC (7:30pm US/Eastern)Why should I use Visual Studio 2010 over SSMS for my database development?Quickly clone a database in SQL Server Management StudioSQL Server Management studio slow connection or timeout when using Windows AuthenticationCan't create database in SQL Server Express 2005Prevent SQL Server Management Studio changing destination DB on restoreSSMS - Is it possible to pass additional connection parameters via Command Line?Is there a developer edition of Microsoft SQL Server 2017 for Linux?SQL Management Studio 2012 not loadingWhat are the notable difference between versions of SSMS?How to prevent SQL files opening new instances of SSMS 17.9.1?
.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty margin-bottom:0;
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
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
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
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
sql-server ssms linux virtualisation
asked Apr 13 at 6:57
opensasopensas
15414
15414
add a comment |
add a comment |
1 Answer
1
active
oldest
votes
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.
2
Adding that ADS also includes many features not available in SSMS as called out in the referenced blog link.
– Dan Guzman
Apr 13 at 9:17
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
);
);
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
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
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
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.
2
Adding that ADS also includes many features not available in SSMS as called out in the referenced blog link.
– Dan Guzman
Apr 13 at 9:17
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.
2
Adding that ADS also includes many features not available in SSMS as called out in the referenced blog link.
– Dan Guzman
Apr 13 at 9:17
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.
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.
edited Apr 13 at 7:17
answered Apr 13 at 7:07
Mr.BrownstoneMr.Brownstone
10.1k32546
10.1k32546
2
Adding that ADS also includes many features not available in SSMS as called out in the referenced blog link.
– Dan Guzman
Apr 13 at 9:17
add a comment |
2
Adding that ADS also includes many features not available in SSMS as called out in the referenced blog link.
– Dan Guzman
Apr 13 at 9:17
2
2
Adding that ADS also includes many features not available in SSMS as called out in the referenced blog link.
– Dan Guzman
Apr 13 at 9:17
Adding that ADS also includes many features not available in SSMS as called out in the referenced blog link.
– Dan Guzman
Apr 13 at 9:17
add a comment |
Thanks for contributing an answer to Database Administrators Stack Exchange!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
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
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
Required, but never shown
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
Required, but never shown
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
Required, but never shown
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
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown