What are the challenges you face when working across database platforms? Take the survey
Options

Backing up schemas

B.SmithB.Smith Posts: 7
edited November 4, 2006 6:18AM in SQL Backup Previous Versions
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?

Comments

  • Options
    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
    James Moore
    Head of DBA Tools
    Red Gate Software Ltd
Sign In or Register to comment.