JxstarToadforMySQL7.2 comparison of database production SQL Method

JxstarforMySQL database comparison SQL method the project developed by Jxstar platform. If mysql Data is used, you often need to compare table results and table data. For details, refer to the following description. Tool: ToadforMySQL_Freeware_7.2.0.2922: sx.guguzhu.com: 861pc20140424www.GuGuZhu.com-

Jxstar for MySQL: How to Make a database and compare SQL items developed on the Jxstar platform. If mysql Data is used, you often need to compare table results and table data. for details, refer to the following description. Use tools: ToadforMySQL_Freeware_7.2.0.2922: http://sx.guguzhu.com: 861/pc/2014/04/24/www.GuGuZhu.com-

How to Create a database and compare SQL statements using Jxstar for MySQL

For projects developed on the Jxstar platform, if mysql Data is used, you often need to compare table results and table data. For details, refer to the following description.

Tool: ToadforMySQL_Freeware_7.2.0.2922:

Http://sx.guguzhu.com: 861/pc/2014/04/24/www.GuGuZhu.com-ToadforMySQL_Freeware_7.2.0.2922.rar

Compare table structure

1. Enable the table structure comparison Function

2. Set the database for comparison

3. Comparison results

Select different content and click the "Synchronize" button in the Wizard:

4. Generate comparison difference SQL

Click the Save button below to create a comparison SQL statement. The comparison is over.

Compare table data

1. enable the data comparison Function

2. Set the comparison Database

3. Select the table to be compared

4. Comparison results

5. Save and compare SQL

You can change the name of data. SQL to avoid deleting the SQL file when you close it directly.

End

Jxstar Platform website: jxstar.com