benchbta.blogg.se

If a differential backup is checked, the full database backup will be automatically loaded.

ApexSQL Diff can use only native and natively compressed SQL backups for SQL comparison, but it is possible to use the differential database backups and select the specific point in time to synchronize with the script folder:Īs seen in the screen shot above, precise information about the creation time and date were included for each differential backup as well as the full backup. ApexSQL Diffenables users to save a database schema as a set of object creation scripts directly from your backup.Īlso, it’s possible to export the complete database to a script folder with a click on the Export data source button in the New project window:įirstly, it is required to specify a script folder as a destination data source in order to synchronize it with a SQL backup as a source. There is no need to waste time and resources on restoring the SQL Server database backup. It might be needed to use the backup instead of the live database to create a SQL database build scripts, and this is where ApexSQL Diffcan help. ApexSQL Diffhas the ability to compare and synchronize a database backup against a script folder, which could be of great help during the development process.