Shulou(Shulou.com)06/01 Report--

Download the latest version of Navicat Premium

Navicat Premium is a management tool that can connect to multiple databases. It allows you to connect to MySQL, Oracle and PostgreSQL databases simultaneously with a single program, making it more convenient to manage different types of databases.

Unlike synchronization, synchronization is an one-time process that synchronizes the schema and data of two databases, and replication is a continuous (automatic) process of replicating data between two databases (although schema updates are also possible). Replication can occur asynchronously so that there is no need to establish a permanent connection between the two databases, or to replicate during off-peak hours (for example, late at night, where there is little traffic on the database server).

The primary role of replication is to create a consolidated repository of all user databases and / or to propagate the same level of information among all users. In both cases, the result is a distributed database where users can access data related to their tasks without interfering with the work of others. Database replication is called normalization in order to eliminate data ambiguity or inconsistency between users.

This article describes how to automate database replication using Navicat Premium's new automation utility.

Create a batch job

We will now use Navicat's automation tools to establish a circular replication between the sakila and sakila2 databases.

To begin, click the "Automation" button in the main toolbar.

Then click New Batch Job in the Objects toolbar to open the New Batch Job tab.

Browse for source connections, databases, and / or schemas on the Objects pane. This will cause the saved jobs for the database to appear in the bottom pane of Available Jobs.

In the Available Jobs pane, select the Data Synchronization job type, and then double-click or drag to move the job from the Available Jobs list to the Selected Jobs list above. (you can delete a job from the Selected Jobs list in the same way. )

Click the Save button on the Automation toolbar and provide a descriptive name in the Save dialog box.

This enables the the Set Task Schedule and Delete Task Schedule buttons.

General Tab

In the General tab of the Task Schedule dialog box, you can provide a description of the task and several options for its execution.

In the Security Options box, you can configure the user or group account under which the task is running. Whether the user is logged in or not, there is also an option to run the task. If you select this option, you will provide the operating system user password in the Windows scheduler when you save the schedule.

You can also choose to run the task hidden and configure it to run on a specific operating system.

Trigger task

The Triggers tab lists the schedule for the task. Tasks can be configured to run on a variety of schedules, including once, daily, weekly, monthly, and only according to any arrangement of each schedule.

Click New... The button that displays the new trigger dialog box:

The same task can be run according to multiple schedules. For example, we can schedule the database synchronization task to run on the first and second Sunday of each month:

Set up email notifications

Navicat allows you to generate and send personalized e-mail messages containing the results returned from the timesheet. The results can be sent to multiple recipients by email. Select the "Send Email" option in the "Advanced" tab and enter the required information.

From

Specifies the email address of the sender. For example, "someone@Navicat.com".

To, CC

Specify the email address of each recipient, separated by a comma or semicolon (;).

Subject

Use a custom format to specify the subject of the email.

Body

Write the content of the email.

Host (SMTP Server)

Enter the simple Mail transfer Protocol (SMTP) server on which the message is sent.

Port

Enter the port number that connects to the outgoing email (SMTP) server.

Use authentication

If your SMTP server requires authorization to send email, select this option and enter a user name and password.

Secure connection

Specify a connection to use TLS, SSL secure connection, or never use.

Send Test Mail

Navicat will send you a test email indicating success or failure.

After you have configured the automation job, you can test it by clicking the Start button in the automation toolbar.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.