We have many customer NAV databases in versions from NAV4 to 2013R2 in our SQL database for development purposes. Currently we daily take a full backup of all databases, because that is the only place we got the objects. However; the total size of the databases are soon causing problems for our backup device. We would therefore like to ignore the actual NAV data of the databases – we actually only need to be able to restore the NAV objects. All developers are allowed to create new databases, so it should be possible for the daily backup to automatically include new databases without any additional configuration.
But is that possible? We have currently considered:
* Only backup the file group with the MDF-file, but is it actually possible to build a new NAV database from only an MDF-file?
* Make T-SQL to export the Object table from all databases, but can that be used to create a new database?
* Switch to a version controls system like TFS to separate the NAV objects from the database. However; we are quite happy with our current much disciplined way of developing and we are using Object Manager in most databases.
* We even considered automating an old FBK objects-only backup using ExpandIT Backup Utility, but from 2013R2 that’s a no-go.
Anyone with a good solution?