Remote data sync
During the data-sync process, it would be cool to be able to define in the data sync file, a remote location to sync tables from. This could be used to do a "one time" sync between two systems, or for a production system to sync row from a test system. This will need the following features:
- Secure. This HAS to be VERY secure, so that no unauthorised access to the system is permitted. The DBI config is already treated as secure so we could add a "sync key" to this.
- Table level. This will sync all rows in a table and will be merged in with rows defined in the data sync file. Rows in the sync file get priority.
- Row level. This will mean adding a filter or custom query to the sync so that only certain rows are sync'd.
- "self" detection. If the data sync is run on the host which is set as the data source of the sync, then we should not attempt to sync remote data.