DBVT MS SQL 2008 Compatibility Fix

In DSP Versions of 7.1 and below, the Syniti Database Versioning Tool (DBVT) SQL object export process was dependent upon some MS SQL 2008 components. If using the DBVT to export SQL objects on a server that does not have those MS SQL 2008 components, the export process fails with a error similar to the following: 

 To fix this export issue:

1. Navigate to the {DSP Install Location}\DSP\Databases\Tools\FOR_SMO_10 folder.
2. Remove any dlls that start with “Microsoft.SqlServer.” 
3. Replace the VersionDatabase.exe.config XML file with the file attached to this article.
4. Edit the VersionDatabase.exe.config file, changing the newVersion number for the Smo and ConnectionInfo assemblies to the version of SQL Server that is installed. Refer to the following MS SQL Server Version Matrix:

 Refer to the following example for items that need to be changed: