provided by: 
Originally published at Internet.comSQLMesh provides the ability to extract meta and code information from Microsoft SQL Server (6.5 - 2005) and/or Sybase ASE (11.x - 15.x) database objects, and then to search that data for each occurrence of specified words or phrases. It can extract table schemas, triggers, views, and stored procedure information (provided they aren't encrypted). It is targeted to DBAs and developers, enabling them, for example, to locate all stored code and procedures that access a particular field.
SQLMesh is a Java based utility, and is accessed via a Web browser interface. A Java Runtime Environment of 1.5 or higher is required for the utility. No code need be installed in the RDBMS itself.
The vendor notes that the utility does not, in fact, extract actual data; but rather builds a collection of relationship links referring to the information contained within each object. These "links" are then used for the subsequent search queries; i.e., continuous access to the database is not required. These links can be deployed to developers or other interested parties as needed; but to update the search data the links must be recreated and redeployed. I.E., the vendor states that such link recreation is necessary "...when it is believed the object changes have been significant."
Three versions of SQLMesh are planned: SQLMesh Personal, SQLMesh Live, and SQLMesh Community.
SQLMesh Personal is a free beta version download and is available now from the vendor's Web site. The personal edition supports extraction from an unlimited number of DBs each with an unlimited number of objects. However, SQLMesh Personal can only be used by a single user; extracted links are automatically stored in the same directory the utility itself was installed into and the browser used to access the extracted links must be local to the machine housing them (i.e., each admin/developer must have both their own copy of SQLMesh Personal as well their own copy of the extracted links). Further, the Personal version does not support wildcard searching.
SQLMesh Live is a vendor hosted version of the utility, where the extracted DB information is uploaded to the vendor's own repository. All developers in the company can then access and search the repository via their Web browsers. SQLMesh Live also adds support for wildcard and regex searches, and additional data relationship information such as object creation dates, dependency trees and more.
Finally, SQLMesh Community is an appliance-based offering where the extracted link repository exists in an on-site appliance; i.e., extracted data is uploaded to the appliance where developers can access it directly without requiring an Internet connection. SQLMesh Community includes the feature set of SQLMesh Live.
SQLMesh Personal is a free beta and is available now. SQLMesh Live and SQLMesh Community are currently in development and are expected to be priced based on monthly fees.
Contact AzureStream for further information.Author: DatabaseJournal Staff
Read article at Internet.com site