PrimalSQL 2017Making database query development and testing a snap, regardless of your database type or vendor.
- Supports multiple database providers from a single tool.
- Access, SQL Server, 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 XML, HTML, Text or CSV.
- Edit Stored Procedures and Views.
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 2017 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 PowerShell Studio, and the ability to export PowerShell GUI scripts.
PrimalSQL. Simple, powerful SQL management.
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
Not a DBA? Can never remember those long table and field names that your database team insists are "self-documenting"? Forgot 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 using PrimalSQL's Query Builder interface.
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.
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.
Latest Version: 4.3.57
- Windows Server 2008 R2 / Windows Server 2012 / Windows Server 2012 R2 or Windows 7 / Windows 8 / Windows 8.1 / Windows 10, 32-bit and 64-bit versions supported
- 15MB free disk space
- 1GB RAM
- Processor capable of running Windows 7
- .NET Framework 4.5
- Visual Studio 2012 Runtime