SQLMesh Personal is a tool for extracting/searching through your Microsoft SQLServer (v6.5-2005) and Sybase ASE (v11.x-15.x) database objects. It will extract table schemas, triggers, views, and stored procedure information (footnote:so long as the text is not encrypted) and enable developers and DBAs alike to search their code for any combination of keywords. SQLMesh will help answer questions like “Where is this stored procedure called from?” or “What tables have a column named <….>?”

The interface is web based and very simple. SQLMesh does not extract actual data, but creates ‘relationships’ based upon information obtained about each object. This not only reduces the amount of time it takes to perform the extraction, but prevents actual copies of your schemas and code from being strewn about. Once an RDBMS server is processed and the ‘capsules’ are created, there is no need to access the server again. This enables a dba to run the process and then give copies of the capsules to all other dbas and developers. Capsules can be recreated if when it is believed the object changes have been significant, to prevent the SQLMesh data from becoming stale. SQLMesh Personal is free for anyone and any company to use. The features of the Personal version include:

• Unlimited number of database servers may be extracted.
• Unlimited number of database objects within each server may be extracted.
• No installation of any code is required on RDBMS.
• The application is 100% java and only requires the local machine to have JRE V1.5 or higher installed and a web browser.
• The application is small at under 200k, with a total of 2 MB for it and all the supporting libraries. This small size plus the fact that it is browser based, means you can run it on the slowest and smallest of machines

There are a few limitations of the Personal edition which are:

• All extracted information will be kept locally in the directory sqlmesh is extracted to
• It is single user only and requires the browser to be local to the runing copy of SQLMesh Personal. If there are multiple developers or DBAs, they each need a copy of SQLMesh Personal AND an extracted copy of the data locally stored.
• Wildcard searches are not permitted