Navicat Premium Enterprise 10 dan Navicat for MySQL versi 10

Navicat Portable

Navicat  ini terdiri beberapa banyak versi, diantaranya: Navicat Premium dan Navicat for MySQL.

PremiumSoft Navicat Premium Enterprise Edition 10.0.10 - Navicat Premium adalah multi-koneksi Administrasi Database alat yang memungkinkan Anda untuk menghubungkan ke MySQL, SQL Server, SQLite, Oracle dan PostgreSQL database secara bersamaan dalam satu aplikasi, membuat administrasi databas untuk beberapa jenis database sehingga mudah. Navicat Premium menggabungkan fungsi anggota Navicat lainnya dan mendukung sebagian besar fitur di MySQL, SQL Server, SQLite, Oracle dan PostgreSQL termasuk Stored Prosedur, Event, Trigger, Fungsi, View, dll.

 

Navicat Premium memungkinkan Anda untuk dengan mudah dan cepat transfer data di berbagai sistem database, atau file teks biasa dengan format SQL yang ditunjuk dan pekerjaan encoding.Batch untuk berbagai jenis database juga dapat bescheduled dan dijalankan pada waktu tertentu. Fitur lain termasuk Impor / Ekspor Wizard, Query Builder, Report Builder, Sinkronisasi Data, Backup, Ayub Scheduler dan banyak lagi.
Fitur di Navicat cukup canggih untuk memberikan pengembang profesional untuk semua kebutuhan khusus mereka, yeteasy untuk belajar bagi pengguna yang baru untuk database server.

(source: sinisterys.blogspot.com)

MySQL Objects Management
Support MySQL Servers 3.21 or above
Support of Drizzle, OurDelta, Percona Server and MariaDB
Create / Drop Databases
Support all MySQL objects: tables, views, procedures/functions and events
Support all subobjects: fields, indexes, foreign keys and triggers
Support of partitioning
Support of character set and unicode
Oracle Objects Management
Support Oracle Servers 8.1 or above (Mac OS X Edition starts from Oracle 8.1.7)
Create/drop schemas
Support all Oracle objects: tables (Normal, External and Index Organized), views, procedures/functions
Support all subobjects: fields, indexes, foreign keys, uniques, checks and triggers
Managing directories, tablespaces, public database links and public synonyms
Managing database links, indexes, java, materialized views, materialized view logs, packages, sequences, synonyms, triggers, types, XML Schema and Recycle Bin
Support of physical attributes
Support of character set and unicode
PostgreSQL Objects Management
Support PostgreSQL Servers 7.3 or above
Create /drop databases and schemas
Support all PostgreSQL objects: tables, views and functions
Support all subobjects: fields, indexes, 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
SQLite Objects Management
Support SQLite 2 and 3
Attach/detach databases
Support all SQLite objects: tables and views
Support all subobjects: triggers and indexes
Support to view master table
Support of character set and unicode
SQL Server Objects Management
Support SQL Server 2000 or above
Support SQL Azure
Create /drop databases and schemas
Support all SQL Server objects: tables, views and functions
Support all subobjects: fields, indexes, foreign keys, uniques, checks and triggers
Managing linked servers, server triggers
Managing assemblies, partition functions, partition schemes and database triggers
Managing indexes, synonyms and triggers
Support of character set and unicode
Connection Management and Navigation
Multiple local/remote server connections
Support of Oracle Basic Connection
Support of Oracle TNS Connection
Support to connect a new or an existing SQLite database
Support encrypted SQLite file (wxSQLite3)
Connection to MySQL/Oracle/PostgreSQL/SQL Server through SSH
Connection to MySQL/PostgreSQL/SQLite through HTTP
Support SSL secure connection for MySQL and PostgreSQL 8.4 above
Keep connection alive
Export/Import connections settings
Customize selected MySQL/PostgreSQL databases to work with
Feature Rich Oracle PL/SQL Code Debugger
Support on showing interactive and real-time debugging information
Ability to set simple and complex breakpoints
Stepping through a function, i.e. Step Into, Step Over and Step Out
Inspecting variables and expressions
Stack traces
Data Viewer and Editor
UUID/GUID generator for PostgreSQL/SQL Server
Grid view
Form view
Text, Hex and BLOB viewer/editor
Oracle BFile viewer/editor
Copying and pasting selected records
Customize display formats
Incremental search, sorting and formatting table grid
Ability to show/hide Oracle and SQLite tables ROWID
Support of raw mode edit: apply MySQL/PostgreSQL/SQLite/SQL Server 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
SQL Processing
Visual query/view builder to facilitate the process of building complicated queries
Ability to create parameter queries
Code completion for SQL editors
Code outline
SQL Code Beautifier/Minifier
Multiple SQL editors with syntax highlighted feature
Support code folding, highlighted matches words and brackets
Copy SQL with quote
Word Wrap
Zoom In/Out for SQL editors
Enhanced find and replace options in SQL editors
Ability to preview SQL before execution
Support to return multi-resultsets
SQL console
Data Modeling Tools
Reverse engineering
Support of several diagram notations like Crow's Foot, IDEF1x and UML
Ability to create/edit/drop database objects, visually set relationships between them
Support of auto layout
Support numerous visual customization options like adding vertices, layers, images and notes/labels
Zoom In/Out for ER diagram
Comparing and synchronizing database/model
Generating complex SQL/DDL
Multi-page print preview
Ability to print the database diagram to PDF file
Ability to save the database diagram as a graphic file, i.e. PNG, SVG
Diversified Import and Export Competence
Importing data from ODBC: MSSQL, Oracle etc
Importing data from MS Excel
Importing data from MS Access
Importing data from plain text file formats : TXT, CSV, XML etc
Importing data from other file formats : DBF etc
Exporting data to MS Excel
Exporting data to MS Access
Exporting data to HTML
Exporting data to plain text file formats: TXT, CSV, XML etc
Exporting data to most popular formats: DBF etc
Other Data Manipulation Tools
Data transfer (Same or cross server type)
Transferring data to SQL script as INSERT statement
Transferring data to a SQL file with designated SQL format and encoding
Data synchronization
Structure synchronization
Backup/Restore for MySQL/PostgreSQL/SQLite
Backing up/restoring database
Backing up database with chosen database objects
Restoring database with chosen database objects
Converting backup file into SQL script
Compressing/Decompressing Backup files
Schedule for Batch Job
Ability to set schedule on backup, query execution, import/export, data transfer and data synchronization
Ability to run profiles from different servers in a single schedule job
Schedule report printing
Schedule to print report to files: PDF, Excel, HTML etc
Sending notification e-mail for schedule task
Ability to attach Export Wizard/Report result files in Batch Job notification email
Notification email Support SSL/TLS
Server Security and Maintenance Services
Visual user management
Visual privilege manager
Ability to duplicate user, role, etc
Maintance database/schema objects
Server Monitor to view and change system variables and server status information
Report Management Tools
Report Builder
Report Viewer
Other Useful Features
ER Diagram view
Ability to customize connection colorings
Support of database wide search
Objects search filter
Backing up database/schema/table to SQL script
Executing SQL script
Duplicate/empty/truncate tables
Create table/view shortcut on desktop
Ability to create Favorites list
Ability to set auto-save for Query, Function, etc
Print database/schema/table structure
Support of docking/tab windows
Support of virtual grouping: provide logical organization over connections and objects
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

  What's New on Premium version:

Reverse Engineer Are you looking for a graphical representation of your relational database? Here it comes with Navicat 10! With the Reverse Engineer in Navicat, you can create a conceptual model from an existing database and graphically visualize and edit the structure of your database. Or, you can graphically create a conceptual model, and generate a database that supports your model.

Compare and Synchronize between Model and Database Synchronize to Database will give you the full picture of all databases differences. Once your databases are compared, you can view the differences and generate the necessary synchronization script to update the destination database and make it identical to your model. Flexible comparison and synchronization settings will enable you to set up a customized comparison key for comparison and for synchronization.

SQL/DDL Script Generation Export SQL gives you the opportunity to get a full control over the final SQL script, generate individual parts of your model, generate referential integrity rules, comments, character set etc. The Export SQL feature may save you hundreds of hours of your work.

More great new features! ER Diagram View Looking for a better view over objects? Now, our new ER Diagram view helps you achieve a better understanding of your database schema by displaying the structure in a graphical format. So, you can see the interrelationships between tables in a database.

Database Wide Search Navicat 10 provides a powerful search function to find records on the entire database. You can search for whole words only, use regular expressions etc to search in. It is particularly useful if you want to limit your search to a particular type of records.

SQL Code Minifier Eliminate unnecessary spaces, line breaks, and indentation come in handy if you want to copy and paste your SQL to anywhere without unwanted whitespaces.

(source: www.navicat.com)

PremiumSoft Navicat for MySQL  10.0.10 - Berbeda dengan kerabatnya yaitu PremiumSoft Navicat Premium Enterprise Edition 10.0.10, program ini hanya dikhususkan untuk pemograman database MySQL. Bagi Seorang Programer pasti nya telah mengenal Software ini,dan bagi programer yang sering berkutat dengan pemograman database seperti mysql, ini layak buat anda coba.

 (source: d4rwis.blogspot.com)

What's new on MySQL versions

Reverse Engineer Are you looking for a graphical representation of your relational database? Here it comes with Navicat 10! With the Reverse Engineer in Navicat, you can create a conceptual model from an existing database and graphically visualize and edit the structure of your database. Or, you can graphically create a conceptual model, and generate a database that supports your model.

Compare and Synchronize between Model and Database Synchronize to Database will give you the full picture of all databases differences. Once your databases are compared, you can view the differences and generate the necessary synchronization script to update the destination database and make it identical to your model. Flexible comparison and synchronization settings will enable you to set up a customized comparison key for comparison and for synchronization.

SQL/DDL Script Generation Export SQL gives you the opportunity to get a full control over the final SQL script, generate individual parts of your model, generate referential integrity rules, comments, character set etc. The Export SQL feature may save you hundreds of hours of your work.

More great new features! ER Diagram View Looking for a better view over objects? Now, our new ER Diagram view helps you achieve a better understanding of your database schema by displaying the structure in a graphical format. So, you can see the interrelationships between tables in a database.

Database Wide Search Navicat 10 provides a powerful search function to find records on the entire database. You can search for whole words only, use regular expressions etc to search in. It is particularly useful if you want to limit your search to a particular type of records.

SQL Code Minifier Eliminate unnecessary spaces, line breaks, and indentation come in handy if you want to copy and paste your SQL to anywhere without unwanted whitespaces.

Latest MySQL versions support

• Compatible with any MySQL server version.
• Support of Events.
• Support of Triggers.
• Support of Stored Procedures and Functions.
• Support of Views.
• VARCHAR Data Type support. Value from 0 to 65,535 in 5.0.3 and later versions.
• BIT Data Type support.
• BINARY/VARBINARY Data Type support.

Well-designed user interface

• Virtual Grouping for categorizing your works.
• Customize of connection order.
• Further data are shown in the tree view.
• Provide better vision for users in table grid.
• Well-described Wizard System.
• Support dock windows.

Powerful data management tools

• Form View support.
• Send notification e-mail for schedule task.
• Foreign Key Auto-Completion.
• Data Synchronization support.
• Structure Synchronization support.
• Support of Tables/Views/Stored Procedures/Events Backup and Restore.
• Support of Tables/View/Stored Procedures/Events Data Transfer.
• Build in SQL Console.
• Supports Parameter Query.
• dBaseIII memo support in DBF Import Wizard.
• Run Selected in SQL editor.
• Raw mode setting allows user to view the actual data value which stored in the MySQL database.
• Manage Users.

Connection options

• Support of HTTP Tunnel.
• Support of Private Key for SSH Tunnel.
• Provide Auto-reconnection for MySQL server.
• Export Registry Record(.reg) via Navicat MySQL.

Visual Designer

• Support Code-Completion in Query, View and Event.
• Support New Query create a query from different databases which are within the same connection.
• Support Views in Query Builder.
• Support of Views Builder.

Additional features

• Support of setting global Row Height and Column Width in table grid.
• WordWrap for Query and View Editor.
• Provides a short-cut to terminate a running query.

    (source: www.navicat.com)



Download:
Carilah link download diantara beberapa tulisan dibawah.
Jika benar, maka mengarah ke alamat download ada 5 buah:
1- NavicatMySQL_10.0.10.paf.exe
2- NavicatforMySQL_10.0.10.paf.exe3- NavicatPremium_Portable_10.0.11.paf.exe
4- Navicat Keymaker.zip
5- Navicat download center
Berkonsentrasilah dan Selamat Berjuang untuk mengunduh filenya! :)
----------------------------------------------------------------------------------

:::::::::::::::::::::::::::::::::::::::::::::::::::::::::::

:::::::::::::::::::::::::::::::::::::::::::::::::::::::::::

:::::::::::::::::::::::::::::::::::::::::::::::::::::::::::

:::::::::::

:::::::::

::::::

::

:

________________________

____________________

_______________

______

 ------------------------------------------------------------------------------

  Terima kasih telah membaca..

dan semoga berhasil serta membantu Anda dalam menyelesaikan pekerjaan Anda. 

ide pembuat: Idhan si Pengelana Cinta dari: http://dhaniesweb.wen.ru

_   

Kategori:

Pengembangan