Home IT Linux Windows Database Network Programming Server Mobile  
           
  Home \ Database \ PLSQL Developer synchronization table tools     - Install the Solaris 10 operating system environment over the network to sparc (Linux)

- Snapshot DataGuard (Database)

- Linux file permissions chmod chown (Linux)

- Java Foundation - The relationship between abstract classes and interfaces (Programming)

- CentOS 6.6 source compiler GCC upgrade to 4.8.2 (Linux)

- curl Usage: Being the first site header and status codes (Server)

- Linux distributed message queue RocketMQ deployment and monitoring - Dual Master (Server)

- CentOS 5.5 install ntop (Linux)

- Android system source code and compile the kernel source code (Programming)

- You can not ignore the seven Git tips (Linux)

- MySQL Server Time Synchronization Problem (Database)

- Android Application Development: Genymotion can not start solving (Linux)

- apt-get and apt-cache show command examples (Linux)

- Linux System Getting Started Tutorial: Using the Linux common commands (Linux)

- HAproxy let IP recording back-end RS (Server)

- Port Telnet command to detect the remote host is turned on (Linux)

- Hibernate learning introductory tutorial (Programming)

- Graphic Git (Linux)

- Zabbix Agent for Linux Installation and Configuration (Server)

- Installation Flow N Play- interface stylized video player on Ubuntu (Linux)

 
         
  PLSQL Developer synchronization table tools
     
  Add Date : 2017-04-13      
         
       
         
  There Compare User Objects and Compare Table Data functions PLSQL Developer Tools option in the menu bar.

A, Tools -> compare user objects

sql script This function is used to compare different objects owned by the user (including table, sequence, function, procedure, view, etc.), and generates a synchronizing difference, the script is executed by the user, the user can synchronize two object structure, Of course, you can also select an object or multiple objects to be compared.

Steps:

1. Select the contrast of the object sample library

2. Select the target library (Target Session ..), namely the need to modify and synchronized libraries

3. Click the Compare button

4. Differences tab, click each object can be viewed eliminate differences in SQL, click Apply SQL in Target Session execution

5. Click the Show Differences button to display specific differences

Two, Tools -> compare table data

sql script This function is used to compare whether some tables inside the data consistent, and automatic generation of synchronization differences, users executing the script can be maintained for comparison and synchronization of data inside an object to be compared.

Steps:

1. Select sample database comparison table

2. Select the target library (Target Session ..), namely the need to modify and synchronized libraries

3. Click the Compare button

4. Differences tab, click on each table can eliminate differences in SQL View

 5. Click Apply SQL in Target Session execution

NOTE: Record the same primary key values do update (Update) other fields.
     
         
       
         
  More:      
 
- HDFS Distributed File System Resource Manager Developer summary (Server)
- Getting Started with Linux system to learn: How to compress JPEG images on the command line (Linux)
- Java study notes: String (Programming)
- Build Eclipse + Maven + Scala-IDEA the Scala Web development environment (Server)
- Three kinds of implementation model of the Linux thread history (Programming)
- CentOS 6.5 installation VNCServer implement graphical access (Server)
- History of the most complex validation e-mail address regular expression (Linux)
- How LUKS encrypted disk / partition to perform remote incremental backup (Linux)
- Ubuntu 14.04 and derivative versions of the user install Pantheon Photos 0.1 (Linux)
- To use Linux to create a secure managed gateway (Linux)
- Oracle 11g principle study Dataguard (Database)
- How do you turn on and off IPv6 address on Fedora (Linux)
- Linux configuration Samba server (Server)
- DDOS Attacks and Prevention (Linux)
- Management and application Oracle external table (Database)
- Using a proxy method under Linux terminal (Linux)
- Mounting Windows shared directory system under the Linux (Linux)
- Java NIO The Glob mode Detailed (Programming)
- Cool Android realization SVG animation (Programming)
- Open remote MySQL database connection managed under CentOS (Database)
     
           
     
  CopyRight 2002-2016 newfreesoft.com, All Rights Reserved.