Hi,
I'm trying to synchronize two databases that are similar but not
exactly the same. I would like to create two connections (db1 and
db2) and go through table by table to do the synchronization.
db1 = DAL('sqlite://storage.db')
db2 = DAL('mysql://username:[email protected]/test_db',
pool_size=10, check_reserved=['mysql'], migrate=False,
fake_migrate=False)
db1 is defined in db.py while db2 is a mysql database (created via
web2py) that already exists and has data in it. i'm trying to update
the data in db2 with the data in db1. What is a good way to deal with
this problem?
Avik
