Skip to content

Write large redcap tables to separate files #73

@pbchase

Description

@pbchase

The monolithic database dump file currently created by REDCap deployment is hard to work with. We should split the largest databases and the schema into their own files so selective restoration of tables is simpler.

To that end, I propose that we dump the redcap_data, redcap_log_event, and redcap_log_view tables into their own dump files. Dump their schema into another file. Dump all other tables into a 5th file. Each file should be compressed and named with a sql.tz extension. Each file should bear the same timestamp so as to mark them as a matched set. All three files should be written to a folder also bearing the same timestamp in its name.

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions