Thanks for the replies..

In my case, the ID is used to store a generated uuid, as a completely unique string. The overall process, is that I have multiple systems, and they each run a local process, with a local db/tbl structure.. I then reconcile all the processes on a centralized mysql db process at a later time..

My process enforces that the ID is essentually unique across all my systems. I don't want to change this approach. Nor do I simply want to have an ID that's an int, simply to use SQLObject...

So.. my goal is to be able to use sqlobject to interface with the existing mysql db/tbl, and to be able to modify/handle an id that's a string...

So what is the problem?
simply connect to both tables, (the Source table and the Target table) using two different connections.

class Source(SQLObject):
    class sqlmeta:
        fromDatabase = True
        idName = "SOURCE_TABLE_ID_NAME" 
        idType= str

class Target(SQLObject):
    class sqlmeta:
        fromDatabase = True
        idName = "TARGET_TABLE_ID_NAME" 
        idType= str

and read data from Source and write it to Target (as you can see in my previous posting). I am not sure about the performance, but I think it must work.

Alternatively you can export a .csv file from the Source table (using SQLobject of course) and than import it to the to the Target table (here is use of the SQLobject not recommended because of the performance issue).

Petr Jakes