QweryBuilder uses innovative ideas to provide developers with the ability to easily insert, extract and modify data from a variety of databases.
The goal of QweryBuilder is to increase a database developer’s productivity. It contains many time saving features.
SQL Editor
QweryBuilder - SQL Editor
- Script auto complete
- Custom auto complete lists
- Code Templates
- Display column list for tables and views in editor
- Display procedure parameters in editor
- Keyboard shortcut to open procedures
- Generate and insert new GUIDs
- Syntax folding
- Auto indenting
Criteria Query
QweryBuilder - Criteria Query
- Form view criteria screen for easy data retrieval
- Updateable result set
- Insert nulls, GUID’s, and computed values into results
- Insert, delete and update data rows
- Generate insert statements from results
- Create graphs from result data
Graphic Query
QweryBuilder - Graphic Query
- Create queries graphically
- Cross table querying without writing SQL
Other Features
- Support for Microsoft SQL Server, Sybase ASE, SQL Anywhere and Oracle
- DDL Browser
- Database Search
- Visual Difference
- Code Formatter
- Getting Started Window
- Displays last used connections, files and database objects
- Easily navigate to the last thing you were working on
- Clipboard Saver
- File Browser
- Object Browser
Tag Archive: SQL Server
Don’t know what VMware VMotion is? VMotion allows you to easily move one virtual machine to another VMware ESX host that is connected to the same storage mechanism (presumably SAN) with no downtime. Looks promising 
Image courtesy of VMware
Dell has a demonstration using Microsoft SQL Server where they move the live SQL Server from one blade to another with no outage:
What I would love to see is native support for SQLite. http://www.sqlite.org
It is the most installed embedded database on the planet hands down. Don’t believe me? You know that Firefox web browser, Thunderbird newsreader, most Adobe products, Miro, etc all have it embedded? – reference http://www.sqlite.org/mostdeployed.html
We use it extensively at work as:
- staging for mass data imports/exports/conversions
- local application ‘cache’ for large data sets
- projects that don’t require all the features of Sybase ASE (or Oracle for that matter)
One of the best features is that the database itself in platform independent… copy the db on to AIX from your Windows box … then on to your old Amiga … then on to your windows mobile device. Getting the point?
I really wish Sybase would make it so that the Sybase ASE databases were truly platform and character set/sort order independent… but that is in another dream 
Not a blurb in the PowerDesigner/PowerBuilder manuals or anything
