Xata DB Clone & Xata permissions
Hello!, i have two questions:
1. Does xata have any option to clone entire databases, with the tables and information inside, to be able to test in develop?
2. Does xata have any options to limit member permissions in workspaces? For example, a member can only access a database in a workspace.
Thanks!, and sorry for my bad english ðŸ«
1 Reply
Hi! For existing production databases, you can use this script to clone databases: https://github.com/xataio/xtools/tree/main/xreplay. It can be used to copy databases across workspaces, regions, or clone to a new branch within the same database. Note, it doesn't copy file attachments.
For the Beta Postgres-enabled databases with direct wire protocol access, use pg_dump to export and psql or pg_import to import to another branch: https://xata.io/docs/postgres#export
Unfortunately there's no member privilege settings at the moment. Member access is workspace-level and grants full read/write permissions to all branches within it.
We will implement a more fine-grained permission scheme in the future. There's a feature request logged here: https://feedback.xata.io/feature-requests/p/rbac-permission-scheme