DataRoamer Features

General:

• Responsive user interface. Database operations run in the background - you're always in control.
• Tool tips and right-click menus eliminate the need to remember commands.
• Adjustable display scale for easier viewing. (50% to 200%)
• Open multiple windows on one or more databases at the same time.
• Table relationships are presented in a tree-like structure for easy navigation.
• Multi-column sorting.
• "Query-less" data selection using a point and click interface.
• Copy data (table, cells, rows, columns) to the clipboard or a file in a variety of formats (CSV, TSV, Microsoft Office, XML.)
• Multiple table views are automatically linked ("joined") to show related data.
• Autocomplete lists for text entry, created from the database.
• Drag and drop to rearrange columns and tables.
• Mouse-over popups display large values.
• Images in the database are automatically detected and displayed.

Performance:

• Optimized data access. DataRoamer is fast!
• Data is cached to further improve performance.
• Memory usage is monitored and controlled. Very large tables can be accessed without causing Windows thrashing.

Databases supported:

• Microsoft SQL Server 2000 and 2005.
• Oracle 9i, 10g, 11g.
• MySQL 5.0.6 and later.
• PostgreSQL 8.0 and later.
• Microsoft Access 2000 to 2007.
• Other databases via ODBC or OLE DB. If the database does not have good SQL-92 and standard interface support, DataRoamer may not provide full functionality for these connections.

For system administrators:

• Licenses issued for 10 or more users can be installed using an msiexec administrative install.