QBS Slogan
QBS Slogan
You are not currently logged in

PrimalSQL  by Sapien Technologies

Using PrimalSQL, you can connect to any database: from Microsoft SQL Server, to Oracle, to Microsoft Access, or even to Microsoft Excel. 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.

Key Features:

  • Database Vendor Independence: PrimalSQL is not constrained by a specific database vendor. You can connect to Microsoft SQL Server just as easily as you connect to Oracle, MYSQL or even Microsoft Access. This gives you independence AND flexibility working with whatever databases you need access to.
  • Visual Query Builder: Wwith PrimalSQL you can create complex queries without expert SQL knowledge using PrimalSQL's Query Builder interface.
  • Mix connections: PrimalSQL lets you connect to any number of databases, mixing vendors and connection types, simultaneously! Enjoy the flexibility of being able to create multiple connections to different databases at the same time.
  • Edit Queries as text: That very same query that you create with PrimalSQL's Visual Query Builder can be edited as SQL text in the SQL Edit Pane. Jump back and forth between visual editing and text editing for even more power and flexibility.
  • Live Query and Edit: You have created a new database and now it's time to test it. Or maybe you just need to develop some new queries for the accounting department. With PrimalSQL's live query and data editing support, ad-hoc queries and testing is even easier than ever.
  • Edit Stored Procedures: PrimalSQL also enables you to edit and create views and stored procedures in an easy to learn environment. Simply select the stored procedure you want to edit, make your changes and save it back to the database. Use the built-in SQL PrimalSense to make writing and editing your procedures even easier.
  • Export Results: Now that you have gotten the results that you need, you need to present them to whomever requested those results. PrimalSQL enables you to easily export the query results to CSV, HTML or XML for further processing or presentation.
  • Quick Script Generation: PrimalSQL enables you at the click of a button to export your query as PowerShell or VBScript either to the clipboard for pasting into PrimalScript (or any other editor) or to a file for later use.
For further details or pricing information, please call +44 (0)20 8733 7101 or email sales@qbssoftware.com