Backup/Restore Specific Tables?
ChristianASPNET
Posts: 7
Hi,
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)?
Best Regards,
David
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)?
Best Regards,
David
Comments
SQL Backup is simply a drop-in replacement for native SQL Backup that addresses storage and security shortcomings in the backup functions of SQL Server. In its' current form, it can back up entire databases, but not individual tables or a cross-section of tables from many databases.
This sort of problem is best addressed by SQL Packager, which can create a self-running SQL script that will reproduce the schema and data that you pick from a database.
SQL Packager can also be automated as part of the SQL Toolkit, if you need to create many packages to reproduce a few databases. SQL Backup doesn't have this option, mainly because you can already perform all of the SQL Backup functions from the command line or by executing a query in SQL Query Analyzer.
Please let us know if you have any more questions.