Backup/Restore Specific Tables?
I work for a company that develops data warehouse solutions. We have a need to backup database schema and specific metadata tables. It's not necessary at all to backup the fact and dimension tables (which can be VERY large), since these are regularly rebuilt from source data.
Does Red Gate's SQL Backup have this capability? If not, is this something that might be added in the future, or would you recommend a different solution (perhaps using the SQL Toolkit)?
MCSD, MCSE, MCDBA