How can we help you today? How can we help you today?

SQL Backup and SQL Compare?

Where would we get more information about using the two together? It almost sounds as if we could restore a table directly from backup without needing to restore the entire DB. Is that correct or am I way off base? That feature would pay for the product very quickly. It's painful to need to restore a full backup when I only need a small number of tables.

Thanks.

-Peter Schott
paschott
0

Comments

1 comment

Sort by
  • Andras B
    paschott wrote:
    Where would we get more information about using the two together? It almost sounds as if we could restore a table directly from backup without needing to restore the entire DB. Is that correct or am I way off base? That feature would pay for the product very quickly. It's painful to need to restore a full backup when I only need a small number of tables.

    Thanks.

    -Peter Schott

    Hi Peter,
    you are right, you can use SQL Compare 7 Pro to restore a database table (or a selected database objects) only. SQL Compare Pro can load in the backup file (both SQL Server backups and Red Gate's SQL Backups). To read a backup you just need to select "Backup" in the SQL Compare project configuration dialog as the "Data Source Type". SQL Compare will be able to restore all the details of your schema directly from the backup. For the data in the table, you can then use SQL Data Compare Pro (Note, that the currently released Data Compare, i.e. not a beta, already has this functionality, and can handle database backups). Concerning more detailed information, we will post some case studies and walktroughs nearer to the final release. In the meantime, please feel free to ask us questions through this forum.

    Regards,
    Andras
    Andras B
    0

Add comment

Please sign in to leave a comment.