05 November 2008

Toolkit for Oracle. GPL

freshmeat.net: "TOra helps the DBA or developer of a database application. It features an SQL worksheet with PL/SQL block parsing, a PL/SQL debugger and editor with syntax highlighting, a Schema browser, Unicode support, printing, and a full suite of DBA management tools."

23 July 2008

sqlDoInstall will help you to install new SQL scripts and keep track of the versions applied to your Oracle database. Freeware

sqlDoInstall 1.7 allows you to rerun a failed script and restart from the point where it has failed in a previous run. It does not apply a driver+script combination that has been installed successfully. The "driver" and the supplied SQL uniquely identifies your script across the database. It'll create two tables: driverinst contains details, and driverinst_head contains a summary of the installation process. SQL installation, schema upgrades, and version tracking are easy.

02 July 2008

sqlDoInstall will help you to install new SQL scripts and keep track of the versions applied to your Oracle database. Freeware

sqlDoInstall 1.6 allows you to rerun a failed script and restart from the point where it has failed in a previous run. It does not apply a driver+script combination that has been installed successfully. The "driver" and the supplied SQL uniquely identifies your script across the database. It'll create two tables: driverinst contains details, and driverinst_head contains a summary of the installation process. SQL installation, schema upgrades, and version tracking are easy.

14 June 2008

Distribution of PostgreSQL. GPLv2

Postgres Plus 8.3.3 is a distribution of PostgreSQL that contains the following additional features integrated in a convenient installation package: Postgres Studio for administration, Procedural Language Debugger, Geospatial extensions, GridSQL Parallel Query, MySQL Migration utility, Slony-II for replication, and pgmemcache for application scaling. The package contains both BSD and GPLv2 licensed software.

10 June 2008

ETL (Extract, Transform, and Load) tool. GPL

Talend Open Studio 2.4.0 can perform jobs that range from datawarehouse feeding to database synchronization, as well as file format transformations. Its graphical interface is made with Eclipse RC P, and data related scripts are generated in Perl or Java. The application was designed to be extended with components written by users.

PL/SQL snippet (embedded in a shell script) which creates a well-formatted HTML report on a given database instance. GPL

OraRep 0.4.3 is a PL/SQL snippet (embedded in a shell script) which creates a well-formatted HTML report on a given database instance, providing you with an overview on your instance(s), some hints for performance tuning, and more. It has been tested with Oracle 8.1.7, 9.0.1, and 9.2. The script easily fits into a cron task to be run on a regular basis. Sample output (HTML) is included. OSPRep does the same job for Oracle StatsPack Reports based on SnapShot Levels up to 7, and provides additional "plugins" for more detailed reporting on special issues. It also optionally creates a separate page with charts to visualize the results and more.

04 June 2008

GUI (graphical user interface) for MySQL. GPL

MyJgui 0.6.1 aims to be easy to use for new users as well as experts. You can store multiple connections that can be used simultaneously. Stored passwords are encrypted using symmetric encryption. Underlying databases and tables are displayed in a tree structure with the connections being the first level nodes. MyJgui is capable of easy data manipulation through a grid. It has a unique feature of bookmarking parametrical queries (sqlmarks). The documentation (user guide) is quite comprehensive and kept up-to-date.

29 May 2008

SQL Server monitoring tool. Freeware, Windows

Simtel.net: "xSQL Profiler is an easy to install, easy to use, agent-less SQL Server monitoring tool that can be utilized for performance, auditing and compliance related tasks. Its simple yet powerful interface allows the user to define custom events by combining low level SQL Server events and applying filters to get exactly what the user wants. The user can then define traces by selecting the events, the servers and/or databases to be monitored and applying additional filters to fine tune the results. The xSQL Profilers scheduling capability allow the user to schedule the traces to run at certain intervals every day, every week or every month on all the selected servers. Finally, xSQL Profilers automatically collects the trace data into a central repository and provides a flexible reporting interface that allows the user to quickly zero in on the data of interest.
xSQL Profiler's powerful filtering capability, advanced scheduling and flexible reporting interface make it a must have tool for SQL Server database administrators.
xSQL Profiler supports SQL Server 2008, SQL Server 2005 and SQL Server 2000."