What is the PSDViewer?
  • A "100%" pure java GUI application designed to facilitate the simultaneous management and querying of multiple RDMS from one application.
 
Tested against the following DBMS:
  • MS Access 97, 2000
  • MySQL 3.23.x, 4.0.x, 4.1.x, 5.0.x
  • Oracle 8.x, Oracle 9.x
  • Microsoft SQL Server 7.0, 2000
  • MSDE 2000
 
Features
  • Explain Query
  • Export Data
  • Import Data
  • Manage Data
  • Query Data
  • Transfer data between DBMSs
  • View DDL
 
Availabe Releases
 
Change Log
  • Support for Microsoft SQL Server 7.0 and 2000 (version 0.50)
  • Corrected DDL generation for tables without `Primary Keys` (version 0.50)
  • MySQL and Oracle DDL format has been enhanced. (version 0.51.1)
  • Application help menus are now available (version 0.55)
  • Internal method calls have been improved (version 0.55)
  • Online application help avaiable (version 0.59)
  • `hosts.*` files can be configured from within the application (version 0.59)
  • MySQL and Oracle `Explain Plan`s incorporated (version 0.60)
  • Archive and Compression method updated to log storage and retrieval information (version 0.61)
  • Included the ability to explain MySQL and Oracle queries (version 0.62b)
  • Updated application help to reflect most recent enhancements (version 0.62b)
  • Performed testing on Mac OsX. (version 0.62g)
  • Added functionality to export data from Oracle and Import into MySQL (version 0.62g)
  • Added functionality to export data from Microsoft SQL Server and Import into MySQL (version 0.62g)
 
In progress ...
  • PSDzip not function on Mac OS (Discovered in version 0.62g)
  • Oracle default date of DD-MON-YYYY is not being properly exported from MySQL during transfer (Discovered in version 0.62g)
  • Reserved words are not being properly escaped during the transfer from MySQL. (Discovered in version 0.62g)
  • Upgrading application to use Connector/J 3.1 - recently released. (Discovered in version 0.62g)
 
System Requirements
  • JRE 1.4 or later installed
 
Acknowledgements
  • MySQL Connector/J 2.0.14
    (Formerly MM.MySQL - Mark Matthews JDBC Driver for MySQL)
    Copyright (c) 2002 MySQL-AB
  • JTDS & Sourceforge for the MS SQL JDBC Driver
  • Sun Microsystems for the Java Technology advancements