PrimalSQL 2011

PrimalSQL 2011 makes database query development and testing a snap, regardless of your database type or vendor. Using PrimalSQL you can connect to any database: from Microsoft SQL Server to Oracle to Microsoft Access or even 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 provides all the tools you need every day to create efficient SQL statements quickly and effortlessly. The application is aimed at anyone who needs to work with databases from a Windows administrator with modest scripting requirements to an enterprise level DBA.

PrimalSQL 2011 has been completely redesigned to use Microsoft's .Net framework. We have added a slew of new features like a new start page for quick access to files, shared database connections with PrimalForms, and the ability to export PowerShell GUI scripts.

PrimalSQL. Simple, powerful SQL management.

Key Features

• Database Vendor Independence

  PrimalSQL is not constrained by specific database vendor. You can connect to Microsoft SQL Server just as easily as you connect to Oracle, MYSQL or even Microsoft Access or Excel. This gives you independence AND flexibility in working with whatever databases you need access to.

• Visual Query Builder

  Not a DBA? Can never remember those long table and field names that your database team insists are "self-documenting"? Forget how to structure that one query you use every two months? Not to worry. With PrimalSQL you can create complex queries without expert SQL knowledge with 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 its 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 or 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

  Need to use a database query in a PowerShell or VBScript script? 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.