Feedback |  Site Map |  About |  Privacy |  Legal
Editor Home  |  Features  |  Videos  |  Download  |  Support  
 


The new ASE Script Library! It now features full color highlighting and collapsible regions (just like in ASE!). Browse, rate, comment and submit your own scripts now!

Home > The Admin Script Editor (ASE) > Features > DB Wizard

ASE offers yet another first in scripting: A simple tool for the generation of complex Database code. Connect to any ODBC data source (Access, SQL, etc.) and select any table or view with which you want to work. Then select the fields you wish to query, update or add. More customization is offered in the "settings" page, but that is all there is to it!

Need more than a simple select, insert or update statement? Right click on databases in the DB Wizard to call the Advanced Query Builder (AQB) where you can create more complex statements like joins graphically be selecting tables, checking fields and dragging fields between tables to specify links.

Generate results in PowerShell, VBScript, KiXtart, or AutoIt!

Click image to enlarge!

Click here for a short training video illustrating the use of this powerful tool!

"Work a lot with databases?  Find yourself using your database's native SQL Query tool?  Maybe you've repurposed Microsoft Access just for the query builder.  ASE answers that with the inclusion of these tools.  Quickly and graphically connect to your target database and easily generate/insert all the code required to make the connections and execute desired queries."  --Dx21.com

Still not impressed? Check out these other features!

 

Download the 45 day trial and see for yourself!

What features matter to you? Choose your scripting language of choice:

>> VBScript
>> PowerShell
>> KiXtart
>> AutoIt
>> DOS Batch


 

Watch videos covering just some of the great new features introduced in ASE