Search the web
Sign In
New User? Sign Up
sw-gis · Smallworld Developers
? Already a member? Sign in to Yahoo!

Yahoo! Groups Tips

Did you know...
Message search is now enhanced, find messages faster. Take it for a spin.

Best of Y! Groups

   Check them out and nominate your group.
Having problems with message search? Fill out this form to ensure your group is one of the first to be migrated to the new message search system.

Messages

  Messages Help
Advanced
Oracle insync-- Selective record export and synchronisaton   Message List  
Reply | Forward Message #19820 of 20137 |
Hi,

I am trying export smallworld data to oracle database with insync tool and version of smallworld is 4.0

I am able to export and doing synchronization  also

But I needs to insert and synchronize only selective records based on one field of the smallworld table

For example: consider pole table is available with fields and values as below in smallworld database 
 idnamestatus
p12xyes
cc1yno 
p11zyes


if i  needs to export and synchronise for above table to oracle
   with condition, if id value starts with "p" then only do export and synchonisation and ignore the remaining records

please help to give the information regarding, is there any methods or procedures for doing above..?

Please help me
kamesh










Fri Jul 10, 2009 3:23 pm

kameshwarara...
Offline Offline
Send Email Send Email

Forward
Message #19820 of 20137 |
Expand Messages Author Sort by Date

Hi, I am trying export smallworld data to oracle database with insync tool and version of smallworld is 4.0 I am able to export and doing synchronization also...
Kameswara rao K
kameshwarara...
Offline Send Email
Jul 10, 2009
3:24 pm

I imagine you have your reasons for only keeping a portion of a table 'InSync' as obviously the rest of it (if existing in the external table) could be...
Harris, Ronnie
rharris@...
Send Email
Jul 14, 2009
5:05 pm

Hi Ronnie, thanq very much for your help I done samething which you explained and i got success without any issues but now i m getting another error while...
Kameswara rao K
kameshwarara...
Offline Send Email
Jul 19, 2009
5:10 am
Advanced

Copyright © 2009 Yahoo! Inc. All rights reserved.
Privacy Policy - Terms of Service - Guidelines - Help