PL / SQL Developer 6 Object Compare Function Description (original)
The object comparison function of PL / SQL Developer 6 is very powerful and practical. It is a must-have tool for developers, mainly with the following uses:
Check different information from all objects in two different databases.
Automatically generate SQL scripts used to match
Commonly used to develop databases and generate database comparison or new databases with old databases
Below I will fully introduce the steps of comparing the PL / SQL Developer 6 object:
1, open the window
Open the Tools / Compare User Objects ... menu, the comparison window is shown below:
The intermediate main area shows all objects currently logged in users, including tables, views, packages, functions, procedures, triggers, sequences, etc., which are comparable objects.
2. Select the object you want to compare from the list, as shown in the above figure, you can use the Ctrl or Shift key multiple selected.
3, set the target database object
Click on the Target session .. button below, the pop-up connection dialog box is shown below.
Enter the username, password, service name of the target database, and note that the username must be a user who is used to compare objects.
4, start comparison
After entering the connection of the target object, click the COMPARE button in the bottom right to start comparison.
There is an option in comparison, default is selected
Include Storage In Generated Ddl for New Objects
If you are not selected, you will not include the storage information of the object (such as table space information, etc.) in the generated script.
Different information between the objects will be automatically displayed after completion, as shown below, if the contrast object DDL statement is exactly the same, no list is displayed.
5. View specific different information between objects
By comparing the list of different objects, you can select the specific different definitions you want to view, and you can also support multiple selections, where you will display objects under the current database user to apply to the target database object.
Note: It has the following cases to generate application scripts.
Number Safety Script Instance 1 Target Object does not exist all script tables that generate the target object does not exist 2 target objects Different generation modification script size Different 3 target objects, but there is no prompt 4 functions, process, Body, trigger, view object definition of different generation replacement objects definitions
6, other operations
After comparison, you can perform the corresponding operation according to your personal requirements.
1. Save the footbook file
2. Copy the script to the Windows clipboard
3. Apply script to the target database (which is more careful to do this, it is recommended to perform this operation after comprehensively checking the script generated, especially some delete operations, because this operation is a batch application, no confirmation prompt.)
4. Display specific different information (very powerful, this is the function of PL / SQL Developer extension with third-party tools, the current version is examdiff1.6)
The current ExamDiff1.6 is in a comparison, but it is still not enough, that is, if you have an examdiff3.2 or 3.3 version, you can point to your comparison tool by configuring comparison tool, The effect of the display is better. I don't make a detailed introduction about the operation of comparative tools.
5. Configure comparison tools (defined according to personal requirements)
2005-03-20
Yasheng
