blocks|key|7067558|text|我用DBeaver。他们的网站上有一个Debian软件包(.deb)。它类似于MySQL工作台。|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|7067559|要安装:从.deb下载下载页面文件，切换到放置DBWeaver+deb的目录中，运行sudo+dpkg+-i+dbeaver-*.deb或为snap用户运行sudo+snap+install+dbeaver-ce，为平板用户运行sudo+flatpak+install+flathub+io.dbeaver.DBeaverCommunity。|style|CODE|entityMap|0|LINK|mutability|MUTABLE|url|https://dbeaver.io/|1|https://dbeaver.io/download^0|2|7|0|0|16|Q|26|S|36|1K|B|4|1^^$0|@$1|2|3|4|5|6|7|Q|8|@]|9|@$A|R|B|S|1|T]]|C|$]]|$1|D|3|E|5|6|7|U|8|@$A|V|B|W|F|G]|$A|X|B|Y|F|G]|$A|Z|B|10|F|G]]|9|@$A|11|B|12|1|13]]|C|$]]]|H|$I|$5|J|K|L|C|$M|N]]|O|$5|J|K|L|C|$M|P]]]]

I use <a href="https://dbeaver.io" rel="noreferrer">DBeaver</a>. There is a Debian package (.deb) available on their website. It is similar to MySQL Workbench.
To install: download the .deb file from the <a href="https://dbeaver.io/download" rel="noreferrer">download page</a>, change to the directory you put the DBWeaver deb in and run <code>sudo dpkg -i dbeaver-*.deb</code> or run <code>sudo snap install dbeaver-ce</code> for snap users and run <code>sudo flatpak install flathub io.dbeaver.DBeaverCommunity</code> for flatpak users.

blocks|key|7067764|text|塞莱琼是一个开放源码、跨平台的SQL客户端，它具有一个干净、简单的GUI，支持Microsoft+(以及PostgreSQL、MySQL、Cassandra和SQLite)。|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|entityMap|0|LINK|mutability|MUTABLE|url|https://sqlectron.github.io/^0|0|3|0^^$0|@$1|2|3|4|5|6|7|K|8|@]|9|@$A|L|B|M|1|N]]|C|$]]]|D|$E|$5|F|G|H|C|$I|J]]]]

<a href="https://sqlectron.github.io/" rel="noreferrer">Sqlectron</a> is an open-source, cross-platform SQL client with a clean, simple GUI that supports Microsoft SQL Server (along with PostgreSQL, MySQL, Cassandra, and SQLite).

blocks|key|8101076|text|在Ubuntu中安装dbeaver的最简单方法是：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|8101077|sudo+add-apt-repository+ppa:serge-rider/dbeaver-ce
sudo+apt-get+update
sudo+apt-get+install+dbeaver-ce|code-block|syntax|javascript|8101078|猎杀河狸：|8101079|dbeaver-ce|8101080|安装后，您可以使用create选项在桌面区域创建快捷方式，并在命令字段中键入"dbeaver-ce“。|entityMap^0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|N|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|O|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|P|8|@]|9|@]|A|$]]|$1|I|3|J|5|D|7|Q|8|@]|9|@]|A|$E|F]]|$1|K|3|L|5|6|7|R|8|@]|9|@]|A|$]]]|M|$]]

The simplest way to install dbeaver in Ubuntu:

<pre><code>sudo add-apt-repository ppa:serge-rider/dbeaver-ce
sudo apt-get update
sudo apt-get install dbeaver-ce
</code></pre>

Run the dbeaver:

<pre><code>dbeaver-ce
</code></pre>

After to install it, you can create a shortcut in desktop area using the option Create Laucher and typing the "dbeaver-ce" in command field.

blocks|key|7068083|text|对于在Ubuntu上使用Visual代码的开发人员，另一个选项是安装Server扩展：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|7068084|https://marketplace.visualstudio.com/items?itemName=ms-mssql.mssql|offset|length|7068085|此扩展允许您访问多个server数据库、直接从IDE以及执行其他操作和任务运行查询和脚本。|7068086|对于简单的用例，我发现对于Ubuntu上的MS访问来说，这是一个快速而简单的选择，而不需要安装单独的软件。|entityMap|0|LINK|mutability|MUTABLE|url|1|https://github.com/Microsoft/vscode-mssql#mssql-for-visual-studio-code^0|0|0|1U|0|0|S|9|1|0^^$0|@$1|2|3|4|5|6|7|R|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|S|8|@]|9|@$D|T|E|U|1|V]]|A|$]]|$1|F|3|G|5|6|7|W|8|@]|9|@$D|X|E|Y|1|Z]]|A|$]]|$1|H|3|I|5|6|7|10|8|@]|9|@]|A|$]]]|J|$K|$5|L|M|N|A|$O|C]]|P|$5|L|M|N|A|$O|Q]]]]

For developers who are using Visual Studio Code on Ubuntu, another option would be to install the SQL Server extension: 

<a href="https://marketplace.visualstudio.com/items?itemName=ms-mssql.mssql" rel="nofollow noreferrer">https://marketplace.visualstudio.com/items?itemName=ms-mssql.mssql</a>

This extension allows you to access multiple SQL server databases, run queries and scripts directly from the IDE, as well as <a href="https://github.com/Microsoft/vscode-mssql#mssql-for-visual-studio-code" rel="nofollow noreferrer">perform other operations and tasks</a>. 

For simple use cases, I've found this to be a quick and easy option for MS-SQL access on Ubuntu, without the need for installing separate software.

blocks|key|7067857|text|undefined，运行在Windows、MacOS和Linux上。一个很好的评论是这里在RedGate网站上。最棒的是，现在有了SQL的扩展，并且intellisense和文档格式也很棒。|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|7067858|我引用他们的网站：|7067859|SQLOPS是用于使用Server的新的开源多平台工具。我们首先看到安装起来是多么容易，然后展示了界面。接下来，我们看了一些常见的任务，比如编辑查询，然后回顾了酷片段特性。最后，我们研究了如何‘窥视’您的数据库。尽管还处于预览阶段，SQLOPS已经有了许多特性，使其成为您的工具包中的一个值得添加的部分。“|blockquote|entityMap|0|LINK|mutability|MUTABLE|url|https://docs.microsoft.com/en-us/sql/sql-operations-studio/download?view=sql-server-2017|1|https://www.red-gate.com/simple-talk/sql/sql-tools/walk-around-sql-operations-studio^0|0|9|0|16|2|1|0|0^^$0|@$1|2|3|4|5|6|7|R|8|@]|9|@$A|S|B|T|1|U]|$A|V|B|W|1|X]]|C|$]]|$1|D|3|E|5|6|7|Y|8|@]|9|@]|C|$]]|$1|F|3|G|5|H|7|Z|8|@]|9|@]|C|$]]]|I|$J|$5|K|L|M|C|$N|O]]|P|$5|K|L|M|C|$N|Q]]]]

<a href="https://docs.microsoft.com/en-us/sql/sql-operations-studio/download?view=sql-server-2017" rel="nofollow noreferrer" title="SQL Operation Studio">SQL Operation Studio</a>, runs on Windows, MacOS, and Linux.
A great review is <a href="https://www.red-gate.com/simple-talk/sql/sql-tools/walk-around-sql-operations-studio" rel="nofollow noreferrer" title="red-gate.com">here</a> on RedGate website. What is great is that now there is an extension for SQL Profiler, also the intellisense and document format are great. 

I quote from their website:

<blockquote>
 SQLOPS is the new open source, multiplatform tool for working with SQL Server. We began by seeing how easy it is to install, then showed the interface. Next, we looked at some common tasks such as editing queries, then reviewed the cool snippets feature. Finally, we looked at how to ‘peek’ into your database. Although still in preview, SQLOPS already has many features that make it a worthy addition to your toolkit."
</blockquote>

blocks|key|7067951|text|您可以使用SQLOps，现在也称为。您应该能够在这里获得它：https://aka.ms/sqlopsstudio：并在Windows或Linux上运行它。|type|ordered-list-item|depth|inlineStyleRanges|entityRanges|offset|length|data|7067952|在完全不同的计算机上运行SSMS，并连接到要控制的计算机和Server实例。|7067953|在服务器机器上安装Oracle的虚拟盒，在VirtualBox中安装Windows，在Windows中安装SSMS。然后将SSMS连接到服务器实例..。|entityMap|0|LINK|mutability|MUTABLE|url|https://aka.ms/sqlopsstudio^0|U|R|0|0|0^^$0|@$1|2|3|4|5|6|7|O|8|@]|9|@$A|P|B|Q|1|R]]|C|$]]|$1|D|3|E|5|6|7|S|8|@]|9|@]|C|$]]|$1|F|3|G|5|6|7|T|8|@]|9|@]|C|$]]]|H|$I|$5|J|K|L|C|$M|N]]]]

<ol>
<li>You can use SQLOps, now also called Azure Data Studio. You should be able to get it here : <a href="https://aka.ms/sqlopsstudio" rel="nofollow noreferrer">https://aka.ms/sqlopsstudio</a> : and run it on Windows, Mac, or Linux.</li>
<li>Run SSMS on a completely different machine and connect to the machine and SQL Server instance that you want to control.</li>
<li>Install Oracle's Virtual Box on the server machine, install Windows inside VirtualBox, and SSMS within Windows. Then connect SSMS to your server instance ...</li>
</ol>

blocks|key|7067605|text|看来还有几个和DBeaver一样的..。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|7067606|SQuirreL+SQL客户端|7067607|/J|7067608|我不得不说，我更喜欢DBeaver，因为它为您下载了所需的驱动程序，并且已经准备好了一个.deb包。|entityMap^0|0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|J|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|K|8|@]|9|@]|A|$]]|$1|F|3|G|5|6|7|L|8|@]|9|@]|A|$]]]|H|$]]

Looks like there are a few other too as well as DBeaver..

SQuirreL SQL Client

SQL Workbench/J

Got to say though I do prefer DBeaver as it downloads required drivers for you and has a .deb package ready made.

I occasionally need to do minor edits to a MS-SQL database running on one of our servers...

I'm using an evaluation of DbVisualizer at the moment to do this (it's Java based and uses something called the jTDS JDBC driver to talk to MS-SQL)... trouble is it's expensive and I'm wondering if there is anything else I can use.

I'm preferably after something which is either a native application (or Java, Python, Perl etc...) but not Windows/Wine/Mono. 

Something which has a similar UI to MySQL Workbench or DbVisualizer which I'm currently using.

Any ideas?

Graphical MS-SQL Clients for a Ubuntu Desktop

翻译质量差，导致语言生硬或混乱。

没有提供实际的解决方法或示例。

解答不清晰，无法理解或解决问题。

页面排版不美观，阅读体验差。

文章

问答

视频

学习中心

腾讯云实验室

直播

竞赛

腾讯云代码分析专区

腾讯iOA零信任安全管理系统专区

腾讯云架构师技术同盟交流圈

腾讯云数据库专区

腾讯云顾问专区

腾讯云原生专区

腾讯混元专区

腾讯云TCE专区

腾讯云Lighthouse专区

腾讯云HAI专区

腾讯云Edgeone专区

腾讯云存储专区

腾讯云智能专区

腾讯轻联专区 

腾讯云开发专区

TAPD专区

腾讯轻量云游戏服专区

腾讯云最具价值专家

腾讯云架构师技术同盟

腾讯云创作之星

腾讯云开发者先锋 

腾讯云代码助手

CODING DevOps

Cloud Studio

SDK中心

API中心

命令行工具

我偶尔需要对运行在我们的服务器上的MS-SQL数据库做一些小编辑.我目前正在使用DbVisualizer的评估来完成这个任务(它是基于Java的，并使用称为jTDS JDBC驱动程序来与MS对话).问题是它很贵，我想知道还有什么可以用的。我的目标最好是一些本机应用程序(或者Java、Python、Perl等)。但不是Windows/葡萄酒/Mono。具有与我目前正在使用的MySQL工作台或DbVi

问Ubuntu桌面的图形MS-SQL客户端
EN

回答 7

Ask Ubuntu用户

Ask Ubuntu用户

Ask Ubuntu用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问Ubuntu桌面的图形MS-SQL客户端EN

回答 7

Ask Ubuntu用户

Ask Ubuntu用户

Ask Ubuntu用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问Ubuntu桌面的图形MS-SQL客户端
EN