Tuesday, January 18, 2005 #

Free SQLServerSearcher application

Awhile back, I started working on a project with a client who had both an old and a new version of a SQLServer database that had to be scrubbed. The new database had also evolved during development, and we needed a way to locate meta data in both databases. I couldn't find anything that met our needs, so I developed a tool myself over a weekend, based on an article Ken Spencer had published on MSDN a few years back. I have since polished up the application, and am now making it available to anyone who finds this blog entry. If you need to search through a SQL Server or MSDE database for text contained in Tables, Views, or Stored Procedures, then try my free SQLServerSearcher application. It runs on Windows NT sp6a or Windows 2000/XP/2003/Vista, and requires the .Net Framework 1.1 or 2.0 (depending on the version -- see below). You really should have one of these installed on your computer by now. Download a zip file containing the 1.1 Framework setup here.
Update: Joel Martinez, the President of the Orlando .Net Users' Group, took a look at the 1.2 release, and made some great suggestions. I  incorporated those into the release (1.3) (2/1/2007: no longer available). Thanks, Joel!
Update: Joel Martinez (see above) found a bug in the 1.3 release using Trusted Connections. I have incorporated a fix for that and some other clean-up into a new release (1.4) available at the link above. I also migrated the code to a .Net Framework 2.0 release, and you can grab that here. This one even works on Vista! Thanks, Joel!
posted @ Tuesday, January 18, 2005 2:02 AM | Feedback (0)