-
Notifications
You must be signed in to change notification settings - Fork 66
Loading Data
work in progress
Load all files in the directory pointed to by the data.dir property:
$ ml local deploy content
Set up a file with the XQSync properties. Let's call it deploy/load.xqs. The Roxy deployer can substitute with properties so that the same config file will work for different environments.
OUTPUT_CONNECTION_STRING=xcc://${ml.user}:${ml.password}@${ml.server}:${ml.xcc-port}/${ml.content-db}
INPUT_PACKAGE=${ml.data.dir}
COPY_PROPERTIES=true
COPY_PERMISSIONS=false
THREADS=4
SKIP_EXISTING=true
ROLES_EXECUTE=${ml.app-role}
ROLES_INSERT=${ml.app-role}
ROLES_READ=${ml.app-role}
ROLES_UPDATE=${ml.app-role}
Then run XQSync:
ml local xqsync load.xqs
Note that Roxy assumes the properties file will be in the deploy directory, so don't specify that on the command line.
Also note that you can make a pull.xqs file to pull data from an existing database by changing the properties above, making this a push or pull tool.
Very similar to using XQSync. See the RecordLoader README for the available properties. Assuming you have set up a file deploy/pull.rl, you can run it like this:
ml local recordloader load.rl
Substitutions work in a recordloader properties file, just like they do for XQSync.