Introduction to PL/SQL developer schema compare

Source: Internet
Author: User

schema compare is really a good thing.
1. Main Functions of Schema compare
compared with the differences between the two databases, including stored procedures, triggers, and table structures.
2. Program Installation
1. first, execute plsqldev902.exe under the PLSQL 902directory for installation. (Same as PLSQL Installation Method)
2. After the installation is successful, click PLSQL developer on the desktop. In the displayed registration window, click keygen.exe in the keygenfolder under PLSQL 902directory. Copy the content of product code, serial number, and password to the product number, serial number, and password text box in the registration information, and click Register.
3. Click deploymentsuitefororacle2.exe in the deployment suite for oraclefolder under PLSQL 902. The installation directory is the same as plsqldev902.
3. comparison using schema compare
1. open PLSQL developer and import the standard library to the new user. Assume that the new user name is tphy_test, the password is tphy, and the database is tphy. Back up the on-site database to a local database and import it to a pre-created new user. Assume that the on-site database username is tphy_xc, password: tphy, and database: tphy.
2. click the blue right arrow in the toolbar above PLSQL developer, and then click the schema compare white label that appears. (if there is no blue arrow in the toolbar, right-click the toolbar and click the custom label that appears, find the blue arrow in the list on the left, click the right arrow in the middle, add it to the list on the right, and click OK in the lower left .)

see: http://download.csdn.net/detail/huang_xw/4676855
required tools: http://download.csdn.net/detail/huang_xw/4677244

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.