navicat mysql gui trial software / shareware for mac

Navicat is sophisticated enough for professional developers, yet easy to learn for new users. It is also available for Windows and Linux and translated into 7 major languages.

Navicat major features:

• Visual Query Builder
• SSH Tunnel for remote database connection
• HTTP Tunnel connection (the same connection way as Webmin or phpMyAdmin)
• Database transfer from server to server
• Data and Structure Synchronization
• Data backup and restore
• Import/ Export of most popular data formats to and from MySQL
• Tasks Scheduling and Easy-to-use wizards tool

Navicat PostgreSQL Manager 8.1.2 is a full-featured Database administration and development tool for PostgreSQL. It works with any PostgreSQL Database Server from version 8.0 or above, and supports most of the latest PostgreSQL features including Trigger, Function, View, and Manage User, etc. Features in Navicat are sophisticated enough to provide professional developers for all their specific needs, yet easy to learn for users who are new to PostgreSQL.

With Navicat well-designed Graphical User Interface (GUI), Navicat for PostgreSQL lets you quickly and easily create, organize, access and share information in a secure and easy way, taking PostgreSQL administration to the next level

Benefits:

• Latest PostgreSQL Versions Support: Navicat PostgreSQL a powerful PostgreSQL Database Server administration and development tool. Highlights of supported features:
• • Support of PostgreSQL versions from 8.0 or above
  • Support of Multiple Connections to local or remote PostgreSQL Server
  • Support of Unicode / Character Set
  • Support of PostgreSQL Views and Functions creation
  • Support of Triggers
  • Support of Foreign Keys
• Additional Connection Options
• • Support of SSH Tunnel: Establish a secure SSH session through SSH Tunneling in Navicat. Enjoy a strong authentication and secure encrypted communications between two hosts. The authentication method can use a password or public / private key pair.
  • Support of HTTP Tunnel: Navicat comes with you HTTP Tunneling while your ISPs do not allow direct connections to their PostgreSQL server but allows establishing HTTP connections. HTTP Tunneling is a method for connecting to a PostgreSQL server that uses the same protocol (http://) and the same port (port 80) as a webserver does.
• Comprehensive Management of PostgreSQL objects
• • Create, edit and drop table's fields, indexes, foreign keys, uniques, checks, rules, triggers and privileges: With Table Designer the basic Navicat PostgreSQL tool for working with tables, you can create, edit and drop table's fields, indexes, foreign keys, checks, rules, triggers, privileges and much more.
  • Dump object definition as sql file: Backup object definition and data with ease by dumping as sql file.
  • View Database / Table Structure: Present the database / table definition by printing their structures in Navicat. Understand the respective object structure fully at a glance.
• Diversified Import and Export Competence
• • Import data up to 5 most popular formats including XLS, CSV, TXT, DBF and XML
  • Import Wizard allows you to import data into a table from diverse format. On top of that, you can save your settings as an import profile for setting schedule.
  • Export Data to different file formats: TXT, CSV, DBF and XML
  • Likewise, Export Wizard allows you to export data into various format. Save your settings as an export profile for setting schedule.
  • Export data and create records as INSERT statements in sql file
  • During Data Transfer, you can choose to export data as sql file with record options like complete insert statements etc.
• Powerful Data Manipulation Tools
• • Support of Foreign Key Data Selection: With the GUI tool Foreign Key Data Selection, you can locate the foreign key values from the reference table. Stop shifting the view to a master table to look for the available values!
  • Data and Structure Synchronization: Navicat for PostgreSQL allows you to transfer data from one PostgreSQL database to another with detailed analytical process. Likewise, you can compare and modify the table structures. For both Data and Structure Synchronization, the target database can be on the same server as the source database or on another PostgreSQL server.
  • Support of Data Transfer between local / remote PostgreSQL databases: Transfer tables / views / functions from one PostgreSQL database to another PostgreSQL database, or to a plain text file.
  • Support of Backup and Restore PostgreSQL databases: Regular backup on database is important to users. Backup / restore all tables and records, views and functions for your PostgreSQL database using Navicat. You can also schedule backups between databases.
  • Create Schedule for Backup, Import / Export, Data Transfer, Saved Queries and Data Synchronization: Create a batch job for setting schedule to execute at one or more regular intervals, beginning and ending at a specific date and time. Batch job can be created for Query, Backup, Data Transfer, Data Synchronization, Import and Export.
• Powerful Security Management
• • Visual User Manager: Navicat provides users a visual tool for user management. You can easily add, duplicate, delete users, and edit global user privileges, and grant privileges on the selected databases, schemas, tables / views and tablespaces / functions.
• Well-Designed Visual Builder / Editor
• • Visual Query / View Builder: Visual Query / View Builder which is divided into two portions: the upper Graphical View, and the lower Syntax View, allows you to create and edit queries / views visually without knowledge of SQL.
  • Query Editor: It allows you to create and edit SQL text for a query, prepare and execute selected queries.
  • Support of Parameter Query: Set query parameters to add variable values to a query each time you run it.
• More great features
• • Virtual Grouping: Have a better organization over connections in Navicat. You can categorize them into groups with the Virtual Grouping feature.
  • Server Monitor: Select the servers that you want to monitor by checking them in the checklist box of the Server Monitor Window. Click on either Process List, Variables or Status icon to show and / or modify the properties of PostgreSQL servers.
  • SQL Console: To use a command-line interface, you can open SQL Console in Navicat. It provides you an interactive text-based screen to query input and result output from database.
  • Tabbed Windows: Customize your window behaviour style. Navicat supports you of dragging windows in and out of the tabbed windows.
  • Text / Blob View: Navicat provides Text / Blob Viewer and Editor to view and edit TEXT / BLOB fields content. The editor allows you to view, update, insert or delete data in a table.

Major Features:

1. PostgreSQL Objects Management
   • Supports PostgreSQL Servers 7.3 or above
   • Create /drop databases and schemas
   • Support all PostgreSQL objects: tables, views and functions
   • Support all subobjects: fields, indices, foreign keys, uniques, checks, rules and triggers
   • Managing tablespace
   • Managing cast and languages
   • Managing aggregates, conversions, domains, trigger functions, operators and classes, sequences and types
   • Support of character set and unicode
2. Connection Management and Navigation
   • Multiple local/remote PostgreSQL server connections
   • Connection to PostgreSQL Server through SSH
   • Connection to PostgreSQL Server through HTTP
   • Support SSL secure connection
   • Customize selected databases to work with
3. Data Viewer and Editor
   • Grid view
   • Form view
   • Text, Hex and BLOB viewer/editor
   • Copying and pasting selected records
   • Customize display formats
   • Incremental search, sorting and formatting table grid
   • Support of raw mode edit: apply PostgreSQL built-in function
   • Support of foreign key data selection: locate the available values from the reference table
   • Filtering Records
   • Ability to set number of records showing on each page
4. SQL Processing
   • Visual query/view builder to facilitate the process of building complicated queries
   • Ability to create parameter queries
   • Multiple SQL editors with syntax highlighted feature
   • Code completion for SQL editors
   • Ability to preview SQL before execution
   • SQL console
5. Diversified Import and Export Competence
   • Importing data from ODBC: MSSQL, Oracle etc
   • Importing data from MS Excel
   • Importing data from other file formats : TXT, CSV, XML, DBF etc
   • Exporting data to MS Excel
   • Exporting data to most popular formats: TXT, CSV, XML, DBF etc
6. Other Data Manipulation Tools
   • Data transfer
   • Transfering data to SQL script as INSERT statement
   • Transferring data to a SQL file with designated SQL format and encoding
   • Data synchronization
   • Structure synchronization
7. Backup/Restore
   • Backing up/restoring database
   • Converting backup file into SQL script
   • Backing up database/table to SQL script
   • Executing SQL script
8. Schedule for Batch Job
   • Ability to set schedule on backup, query execution, import/export, data transfer and data synchronization
   • Sending notification e-mail for schedule task
   • Ability to attach Export Wizard/Report result files in Batch Job notification email
9. Server Security and Maintenance Services
   • Visual user manager to administer users, groups (roles) and privileges
   • Analyzing, vacuuming and reindexing tables
   • Server Monitor to view system variables and server status information
10. Other Useful Features
    • Duplicate/empty/ truncate tables
    • Create table/view shortcut on desktop
    • Print database/schema/table Structure
    • Support of docking/tab windows
    • Support of virtual grouping: provide logical organization over connections
    • Ability to run profile from command line
    • Log files: keep track on the actions have been performed in Navicat
    • Ability to copy Connection Information into Clipboard

Enhancements:

• Improvements:
• • Support quitting the Console window by "q" command.
  • Now owners of objects are not compared or transferred in Structure Synchronization and Data Transfer.
  • Improved the stability when running a query.
  • Improved an internal SQL which run slowly in the past.
• Bug Fixes:
• • Some windows size and position were not saved after closed.
  • Recalling multi-line history commands in Console were not displayed properly.
  • "Copy to Clipboard" did not show host name.
  • Dump SQL File did not dump the primary key definition.
  • Could not recognize the host by host name.
  • User defined type fields were not showing the type properly in Table Design.

Requirements: Mac OS X 10.4 Tiger or 10.5 Leopard

Also, Navicat provides a number of tools allowing to perform all the necessary database operations such as creating, editing, and duplicating database objects. It also offers a well-described wizard system that simplifies your database development tasks and a full featured graphical manager for setting the users and access privileges.

Navicat for Oracle can connect to any Oracle Database version 9i and later and runs on Windows and Mac OSX with remote connection capability. Navicat is also available for MySQL and PostgreSQL.

Easy installation and intuitive interface make it an irreplaceable tool for Oracle on the web or your local desktop.

Navicat full version includes more powerful features such as Data/Structure Synchronization, Import/Export, Backup, Report, task scheduling, code completion, etc. Together with comprehensive and instant support services, Navicat Oracle makes database and application development faster and easier while simplifying day-to-day administration tasks.