Welcome Guest Login SignUp

Home

Technical

Functional

CNC

AS400

DB2

    Citrix

JDE News

Live Radio

Feedback

JDE Forum Comments/Reviews/Queries
1550 day(s) ago   #220
Name: Nick
Category: Technical
Location: India
Date: 2016-02-26 01:10:42
Replies(0)

Status:
  #220

SQL Used to Compare Records in Tables From Different Environments

Following SQL script is very handy in finding records that are in one table but not in the same table in a different environment.

SELECT * FROM [JDE_DEVELOPMENT].TESTCTL.F951000
EXCEPT
SELECT * FROM [JDE_PRODUCTION].PRODCTL.F951000

Script can also be utilized to do the insert of those records that are missing by adding an INSERT INTO statement.

INSERT INTO [JDE_PRODUCTION].PRODCTL.F951000
SELECT * FROM [JDE_DEVELOPMENT].TESTCTL.F951000
EXCEPT
SELECT * FROM [JDE_PRODUCTION].PRODCTL.F951000

Post Comments/Queries
Email:*
Name:*
Details:*
 
   
* Required Entry Field(s).  * Your comments may subject to varification.  * Your email ID will not appear in the forum.
 
Disclaimer: Most of the posts in this blog cater solutions/suggestions/workaround to issues for specific tools release or JDE E1 version and are just information only. Please be carefule while applying it in your environment. JDEthread will not be responsible for any data loss or spec corruption (if any).
Copyright © 2010 - 2020 JDEthread.in