JavaBlog.fr / Java.lu Database Tool/Oracle SqlDeveloper : Access to Sybase, SQL Server databases

Tool/Oracle SqlDeveloper : Access to Sybase, SQL Server databases

Hi,

PL/SQL Developer is an Integrated Development Environment that is specifically targeted at the development of stored program units for Oracle Databases. However, it is also possible to access to Sybase databases.
Below, the main Features of SQL Developer:

  • Database connections
    – OS authentication, Proxy, LDAP
    – Force thick driver usage
    – Group connections in folders
  • Navigator support for
    – Queues, Queue tables
    – Browse and load Java
    – Generating DB documentation
    – Managing the database
  • Schema copy and compare
  • Create new table on XLS import
  • Tuning support
    – Hierarchical Profiler
    – GUI view of trace files
  • SQL Worksheet includes
    – Updated SQL formatter
    – Code refactoring options
    – Increased code insight
    – Code templates
    – Flashback
  • Extended search
  • Integrated support for versioning and source control systems:
    – CVS and Subversion
  • Migration
    – Sybase Adaptive Server
  • Integrated support for TimesTen
    In-memory database



First, it is possible to configure external drivers in SqlDeveloper:
Select the ‘Preferences’ item in ‘Tools’ menu:
1

Tools -> Préférences -> Database -> Third-Party:
2
…then, it is necessary to add an entry by selecting the ZIP file of jTDS JDBC Driver jtds-1.2.7.zip. This jar is an open source 100% pure Java (type 4) JDBC 3.0 driver for Microsoft SQL Server (6.5, 7, 2000, 2005, 2008 and 2012) and Sybase Adaptive Server Enterprise (10, 11, 12 and 15).

3

…after this adding, a new tab SQLServer and Sybase opened in the ‘Database Connection’:
4

That’s all!!!!!!!

Huseyin OZVEREN

Leave a Reply

Your email address will not be published.

Time limit is exhausted. Please reload CAPTCHA.

Related Post