SAPIEN PrimalSQL 2023 v4.5.81 x64

一款功能强大的数据库脚本编辑软件，也可称作数据库管理，用途明确，所以被很多用户使用，也收获众多好评。具备连接数据库功能，不管是什么数据库，常见的sql server、Oracle、mysql还是不常见的Access、Postgresql等等都有连接方案，并且连接也很方便，如果您没有系统学习这么连接配置也没关系，这里有可视化界面，根据提示一步步操作就能顺利的完成连接，对于常用的数据库，小编建议保存连接配置，这样下次需要使用的时候直接连接就好，无需配置，更加方便一些。连接了数据库后就可以进行操作了，像是查询和编辑都具备可视化界面，不过一般情况下是不会用到编辑的，这也是软件倡导的安全。可视化查询就是利用图标界面查看信息，比如说您像查看一张表中的一些数据，需按照创建时间来排序，那就可以将点击时间单元格，这样就可以根据时间排序，其它排序也是类似的操作。但对于多表查询就得利用到查询语句了，当然也有可视化操作查询多表功能，但小编并不是很建议，毕竟难度比sql还高。查询结果可导出，导出格式可选txt文本或者是html等格式，便于查看结果，此外还能编写查询脚本导出，这样下次一样的查询更加快速方便。

File Size: 58.3 MB

Using PrimalSQL, you can connect to any database: from Microsoft SQL Server, to Oracle, to Microsoft Access, to PostgreSQL or even to MySQL. PrimalSQL can be used to build rich and complex queries. From within the application, you can test and refine queries, export results, or generate code snippets in a variety of languages. Its modern, streamlined interface makes PrimalSQL easy to understand and use.

From simple select statements to complicated outer joins, from just checking if a connection works to editing stored procedures and live data, PrimalSQL has all the tools you need every day to create efficient SQL statements quickly and effortlessly. PrimalSQL also provides access to shared database connections with PowerShell Studio, along with the ability to export PowerShell scripts, PowerShell GUI scripts, and VBScripts. The application is useful for anyone who needs to work with databases, from a Windows administrator with modest scripting requirements to an enterprise-level DBA.

Supports multiple database providers from a single tool.
Access, SQL Server, SQL Server Compact, MySQL, Oracle, ODBC, OLEDB, Sybase and more.
Build complex queries with the Visual Query Builder.
Use the Database Browser to explore the different connections.
Generate query scripts for Windows PowerShell and VBScript.
Generate Windows PowerShell GUI scripts from custom queries.
Format query strings for PowerShell, VBScript, C++ and HTML.
Export query results to HTML, XML, CSV or Text.
Edit Stored Procedures and Views.

转载请注明：0daytown » SAPIEN PrimalSQL 2023 v4.5.81 x64