Thursday, March 24, 2005

alternatives for sqlplus/enterprice manager console

Several alternatives exsist for oracle's sqlplus/enterprice manager console. Some of them free (gpl), some of them commercial.
  • www.sqltools.net brings a free lightweight oracle client, but unfortunately without support for spatial fields.
  • www.sqlpal.com has a free java client that can connect through jdbc, for that reason it doesn't need oracle client to be installed at the local machine. sqlpal can't show spatial fields either.
  • www.toadsoft.com sells a commercial client which can show spatial fields, and a free client which can not (free license has to be updated every 3 months).
  • www.dbtools.com sells a commercial client that can connect to lots of databases, including oracle (display of spatial fields unknown). Their free license can connect to mysql, postgres, interbase and sqllite. Very usefull to convert msAccess to MySql

No comments: