| |
My python script looks as below :
IDLE 1.2.1
>>> import arcgisscripting , sys, os
>>> gp = arcgisscripting.create(9.3)
>>> gp.AddToolbox("Data Management Tools.tbx")
>>> gp.SynchronizeChanges("Database Connections\UK Server 10.125.20.102.sde","SDE.BangToUK_Rep", "Database Connections\Bangalore Server 10.175.224.87.sde", "FROM_GEODATABASE2_TO_1", "IN_FAVOR_OF_GDB2", "BY_OBJECT","TRUE")
host = 'v-bnwsihsdv09.ihs.internal.corp'
port = 1521
dbase = 'iris21'
login = 'sde'
passwrd = 'sde'
dsn = cx_Oracle.makedsn(host, port, dbase)
connection = cx_Oracle.connect(login, passwrd, dsn)
c = connection.cursor()
result = c.execute("""UPDATE SDE_PRV_LIN_1_H1 SET USERNAME = 'IHS' WHERE USERNAME <> 'IHS'""")
result = c.fetchall()
print result
res = c.execute("""UPDATE SDE_PRV_LIN_1_H1 SET DESCRIPTION = 'www.ihs.com' WHERE DESCRIPTION <> 'www.ihs.com'""")
res = c.fetchall()
print res |