SQLPro Studio 简介:
SQLPro Studio for Mac是一款可视化数据库管理工具,为创建MySQL,MSSQL,Oracle和Postgres连接提供支持的数据库管理解决方案,包括SSH隧道功能。SQLPro Studio为您提供了通过相同的用户Valentina Studio Pro界面使用多种数据库类Postico型的可能性。该实用程序允许您连接到MySQL,MSSQL,Oracle和TablePlusPostgres数据库,并可用于在多个表上运行自定义查询。
通过内置管理器配置和建立数据库连接
为了帮助您访问数据库而不浪费任何时间的凭证,SQLPro Studio带有一个连接管理器,使您可以保存数据库配置文件供以后使用。
根据数据库类型,您需要提供主机或服务器名称,身份验证方法,登录凭据,服务器端口,SID或服务名称,时区等。
值得一提的是,在某些数据库类型的情况下,SQLPro Studio也可以配置为通过SSH隧道来传输流量,这意味着您可以保持数据交换的私密性。更重要的是,SQLPro Studio可以用于云服务,如Amazon,Microsoft Azure或Heroku。
创建自定义数据库查询,并同时查看多个表的结果
建立连接后,SQLPro Studio将为您提供查看数据库结构并决定配置新查询的可能性。请注意,在SQLPro Studio主窗口中,您可以打开多个视图和查询面板:应用程序将通过选项卡保持所有组织。
SQLPro Studio集成了自动完成功能,语法突出显示支持,以及使用查询结果的可能性,就像在电子表格中一样。另外,SQLPro Studio还可以帮助你更新表格内容,甚至设计新的表格。
可用于比较查询结果的多功能数据库管理解决方案
除了SQLPro Studio可以连接到多种类型的数据库之外,您还可以使用其功能来运行自定义查询并将结果组织到选项卡中。因此,您可以在不同的面板之间切换并快速分析数据。
SQLPro Studio为您提供了查看数据库结构,在多个表上运行查询,管理表内容或设计等等的可能性。



官方简介:
Database management solution that provides support for creating MySQL, MSSQL, Oracle, and Postgres connections and includes SSH tunneling capabilities
offers you the possibility to work with multiple database types via the same user interface. The utility allows you to connect to MySQL, MSSQL, Oracle, and Postgres databases and can be used to run custom queries on multiple tables.
Configure and establish database connections via the built-in manager
To help you access your databases without wasting time with the credentials on each occasion, SQLPro Studio comes with a connection manager that enables you to save database profiles for later use.
Depending on the database type, you need to provide the host or server name, the authentication method, the login credentials, the server port, the SID or Service name, the timezone, and so on.
Worth mentioning is that, in the case of certain database types, can also be configured to route the traffic through an SSH tunnel, which means that you have the possibility to keep the data exchange private. What’s more, can be used with cloud services, such as Amazon, Microsoft Azure, or Heroku.
Create custom database queries and see results for multiple tables at the same time
Once you establish a connection, SQLPro Studio offers you the possibility to see the database structure and decide to configure new queries. Note that within the SQLPro Studio main window you get to open multiple views and query panel: the app will keep everything organized via tabs.
SQLPro Studio integrates auto-complete capabilities, syntax highlighting support, and the possibility to work with the query results just like you would do in a spreadsheet. In addition, SQLPro Studio can also help you update table contents, or even design new tables.
Versatile database management solution that can be used to compare query results
Besides the fact that SQLPro Studio can connect to multiple types of databases, you get to use its capabilities to run custom queries and organize the results into tabs. As a result, you get to switch between the different panels and quickly analyze the data.
SQLPro Studio offers you the possibility to see the database structure, to run queries on multiple tables, to manage the table content or design, and much more.