Using a backup of AuthAnvil 3.5 or earlier, it will not properly restore the backup to an AuthAnvil 4.x installation. An error message comes up during the restore:
If using aarestore.exe: Restore failed. Error: SqlDateTime overflow. Must be between 1/1/1753 12:00:00 AM and 12/31/9999 11:59:59 PM.
If using AuthAnvil Installer: Setup encountered an error while attempting to restore data to the AuthAnvil database. (Full errors are written to a setup log)
The backup script included with older versions of AuthAnvil (v3.5 and earlier) has missing fields from what AuthAnvil v4.x is expecting so it cannot restore properly.
If the previous AuthAnvil server is still accessible, download the newest aabackup.exe tool from www.scorpionsoft.com/downloads. This will backup to a file that is properly formatted for AuthAnvil v4.
In order to directly convert an older backup into the new format for AuthAnvil v4, download the Backup Converter powershell script: http://www.scorpionsoft.com/support/media/AABupConverter.ps1
To convert a backup simply open PowerShell 2.0, change directory (cd) to where the AABupConverter is stored, and run .\AABupConverter.ps1 <backup filepath.bup>. This will create a file called UpdatedBackup.bup. Restore the database using either the aarestore.exe tool at C:\Program Files\Scorpion Software\AuthAnvil\AuthAnvilTools\aarestore.exe or New Install and Restore Data in the AuthAnvil Installer, and the UpdatedBackup.bup file.
All backups from AuthAnvil v3.5 and earlier being used to restore an AuthAnvil v4.x server
If you have any questions or need some help, we would be happy to assist. Open a case at kaseya.zendesk.com .