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.










share|improve this question





























    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.










    share|improve this question

























      3












      3








      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.










      share|improve this question














      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













      share|improve this question











      share|improve this question




      share|improve this question










      asked yesterday









      opensasopensas

      15414




      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





















          • 2





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

            – Dan Guzman
            yesterday












          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


















          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









          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





















          • 2





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

            – Dan Guzman
            yesterday
















          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





















          • 2





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

            – Dan Guzman
            yesterday














          6












          6








          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















          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














          share|improve this answer



          share|improve this answer








          edited yesterday

























          answered yesterday









          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
            yesterday














          • 2





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

            – Dan Guzman
            yesterday








          2




          2





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

          – Dan Guzman
          yesterday





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

          – Dan Guzman
          yesterday


















          draft saved

          draft discarded




















































          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.




          draft saved


          draft discarded














          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





















































          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







          Popular posts from this blog

          數位音樂下載

          When can things happen in Etherscan, such as the picture below?

          格利澤436b