Skip to main content
Question

vbr wildcards and using different vbr version

  • October 23, 2020
  • 0 replies
  • 0 views

Bryan_H
Forum|alt.badge.img+2

JPMC has a group still on 7.2, they are planning to upgrade but need some vbr help first. They want to run object-level backup and restore but would like to be able to use wildcards to avoid e.g. copying all 500 tables in a schema when they just need the ones starting with "WCP_". Is it possible to use the newer vbr from 9.0.1, which supports wildcards? If not, is there another workaround to list a subset of tables by regex pattern rather than having to dump from the catalog (not practical since the tables change periodically)?