© 2007 אופיר אברהמוב

Seekwell – סקריפט ASP לעבודה מול דטאבייסים

Seekwell is a single ASP file you upload to a server (as opposed to the great but huge phpMyAdmin), letting you perform many usefull tasks for web developers working on remote sites without proper access to the database and files.

Features:

  • Single file, 122kb (just drop it in the folder for a second of use, and then delete it…)
  • Ms Access, MS SQL, MS Excel connection (no need for physical path, just use “*” to state server.mappath)
  • Database management tools – viewing and editing tables, stored procedures and views.
  • multiple table results (as in Ms Query Analyzer)
  • Text selection for parts of queries
  • clicking a cell in a result table will return a sql “update” sentence.
  • Marking a chosen text phrase in every string typed cell of any queried table.
  • Exporting a table to CSV
  • Exporting a table to “Insert into” sql sentences
  • Database backup (cloning MDB file, or SQLDMO backup if exists on the server)
  • Checking for a small set of serverobjects (maybe 1% of the great “installed objects scanner”)
  • Treeview of the folder structure, with filecount and sizecount
  • sending emails with attachments (stating physical path on the server) using any SMTP server (enabling authontication)

Not including:

  • Non-IE browser support. All images are using the “windings” font which is not enabled in Firefox.
  • Bugfixes for a few GUI bugs

Download seekwell.zip. (password is “demo”, can be changed in line 15 of the code)

script was written by Ofir Avrahamov – the responsibility of any action made with the script is on the user and I am not incharge by any means to any result or damage made by using the script.

GUI design – Eyal Shahar

seekwell