Backing up schemas

B.Smith

We utilize several caching databases, where the connected application pulls external data when necessary, but otherwise just uses what data is currently in the database. In a failover (or DR) situation, we would really only need to restore the schema, and let the application re-pull the external data as necessary. Can SQL Backup do this?

James Moore

Hi there,

SQL Backup could be used to do this if you backed up and then restored an empty database - then you would just have a backup of the schema with no data in it.

However you might also want to look at some of our other products which could help you in this situation - SQL Compare would allow you to immediately generate a creation script for the schema of the whole database by comparing your template database against a blank database - SQL Packager will take this a step further and create an executable which will deploy your database for you. You can find more information about both of these products at the following URLS:

http://www.red-gate.com/products/SQL_Compare/index.htm
http://www.red-gate.com/products/SQL_Packager/index.htm

If you have any questions about either of these products or which might suit you better then please feel free to post in this forum or one of the other product forums or get in contact with our sales guys (sales@red-gate.com or 1-866 733 4283/+44 (0)870 160 0037) and they should be able to answer any presales questions you have.

Hope this helps,

- James
--
James Moore
Red Gate Software Ltd