Changes between Version 1 and Version 2 of UserGuidelines/Admin/DataMigration/Haiti

Timestamp:

01/16/10 21:48:04 (15 years ago)

Author:

Fran Boon

Comment:

--

UserGuidelines/Admin/DataMigration/Haiti

@@ -1 +1 @@
 == Data Migration ==
 
-  * CSV (beware DB locks!)
-   {{{
-   python web2py.py -S prod -M
-   db.export_to_csv_file(open('db.csv','wb'))
-   Ctrl+D
-   }}}
-   Remove reference Tables from CSV file (don't want to import duplicates!)
-   {{{
-   python web2py.py -S dev -M
-   db.import_from_csv_file(open('db.csv','rb'))
-   db.commit()
-   Ctrl+D
-   }}}
-  * Web services (better to avoid locks)
+=== CSV ===
+Beware DB locks!
+ * Don't keep Web2Py shell open longer than necessary
+
+{{{
+python web2py.py -S prod -M
+db.export_to_csv_file(open('db.csv','wb'))
+Ctrl+D
+}}}
+
+Remove reference Tables from CSV file (don't want to import duplicates!)
+
+{{{
+python web2py.py -S dev -M
+db.import_from_csv_file(open('db.csv','rb'))
+db.commit()
+Ctrl+D
+}}}
+
+=== Web services ===
+better to avoid locks
    * Currently needs to be done resource by resource (JOINed tables can be done together as Components of main resource)
     * need to do referenced tables before the tables which refer to them
@@ -20 +27 @@
    * Ideally we want to develop a way of having all tables loaded together into RAM, refs fixed-up & then imported to db together
 
+=== Synchronisation ===
+BluePrintSynchronisation