When trying to restore a backup of the SQL databases (BSJobs, Fastlane, Fastlane_TM) from an earlier version of SQL (SQL 2000 or SQL 2005 (version 8)) into SQL 2012 (version 11), the databases could not be restored due to version incompatibility.
SQL databases will not restore. Error message mentions that the database versions are not compatible. A version 8 database will not restore in a SQL version 11.
Database BSJobs could not be created.
com.microsoft.sqlserver.jdbc.SQLServerException: The database was backed up on a server running version 8.00.2039. That version is incompatible with this server, which is running version 12.00.4100. Either restore the database on a server that supports the backup, or use a backup that is compatible with this server.
The old database needs to be compatible with the latest version possible. In the SQL Server Management Studio Express, Log into SQL instance using "sa" as the user name.
Browse to the BSJobs database, right-click and select Properties.
Go to Options.
Change the Compatibility level: to the highest level available. Save the changes and make a backup on this database. The database will need to be restored in the version specified in the Compatibility level, changed to the highest level again, saved and a new backup made. This new backup should be restored in the SQL 2012 version.
You first need to restore this database onto a SQL 2005 or 2008 Server, then set the highest compatible level, then make a backup again. This new backup can then be restored on SQL Server 2012 or 2014.
Different SQL versions
SQL Server 2000
Microsoft SQL Server 2000 - 8.00.760 (Intel X86) Dec 17 2002 14:22:05 Copyright (c) 1988-2003 Microsoft Corporation Developer Edition on Windows NT 5.1 (Build 2600: Service Pack 2)
SQL Server 2005
Microsoft SQL Server 2005 - 9.00.1399.06 (Intel X86) Oct 14 2005 00:33:37 Copyright (c) 1988-2005 Microsoft Corporation Developer Edition on Windows NT 5.1 (Build 2600: Service Pack 2)
SQL Server 2008
Microsoft SQL Server 2008 (SP1) - 10.0.2573.0 (X64) Feb 4 2011 11:27:06 Copyright (c) 1988-2008 Microsoft Corporation Developer Edition (64-bit) on Windows NT 6.1 <X64> (Build 7601: Service Pack 1)