PrimalSQL 2009 Features
You say that you are NOT a PrimalScript user? You can now get a powerful stand-alone SQL tool that can work in conjunction
with whatever other tools you use. PrimalSQL is the new and easy to use SQL Query tool from the people that brought you PrimalScript.
You can click on most thumbnail images for a larger view.
 |
Core 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.
- 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.
- 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. Finally get that query working the way you want?
Save it in PrimalSQL for future use.
- 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.
- On-the-Fly Connection Switching
Have a sophisticated query that you need to run against different databases using different connections? Not a problem
for PrimalSQL. Easily switch connections on the fly to run a query against multiple data sources.
- 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.
- 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.
- 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.
- Browse/Edit Database Structure
First time you have had to work with a specific database? Or maybe its been a long time since
you last looked at this specific database. PrimalSQL makes exploration of your database structure simple. PrimalSQL's
versatile user interface displays your structure in an expanding tree control and makes all of that information available
at your fingertips in its SQL PrimalSense.
- 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.