wiki:DeveloperGuidelines/DatabaseSynchronization

Version 1 (modified by Fran Boon, 14 years ago) ( diff )

--

DeveloperGuidelines

Database Synchronization

All tables which should be replicated need 2 fields:

SQLField('modified_on','datetime',default=now), # Needed for T2's conflict detection anyway
SQLField('uuid',length=64,default=uuid.uuid4()),

Export tables as CSV:

Need clear list of which tables to include - e.g. not lookup lists which are the same across sites, not GIS_keys

Import tables at the other end:


DeveloperGuidelines

Note: See TracWiki for help on using the wiki.