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

Backup step not included in script

rgfriendrgfriend Posts: 21 Bronze 2
edited June 15, 2011 10:44AM in SQL Compare Previous Versions
When I use SQL compare to do the comparsion, I see there is an option to do the database backup.
But the script generated doesn't include backup script.

Is anywhere I can generate a backup script in SQL compare?


  • Options
    Hi there,

    Thanks for your post. Unfortunately, SQL Compare runs the backup task as a separate entity to the actual sync script. There is nothing to stop you through scripting out either a native backup job or a backup job using SQL Backup to create a back and bolting that on to the beginning of the sync script generated by SQL Compare.

    We are contemplating adding pre and post deployment scripts, where you could just add in your own backup script but this isn't going to happen for a while yet I'm afraid, if implemented at all.


    Peter Peart
    Red Gate Software Ltd
    +44 (0)870 160 0037 ext. 8569
    1 866 RED GATE ext. 8569
Sign In or Register to comment.