Db versioning
I am trying to create a dbVersion using SubSonic, but when I execute the following command:
C:\Program Files (x86)\SubSonic\SubSonic 2.1 Final\SubCommander\sonic.exe
version /out Generated\dbVersions\
I am getting the following error:
Could not load file or assembly
'Microsoft.SqlServer.Management.Sdk.Sfc, Version=10.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91'
or one of its dependencies. The system cannot find the file specified.
How can I solve this problem?
I'm going to assume that you are using SQL 2008? Take a look here: http://msdn.microsoft.com/en-us/library/cc284267.aspx
You need to demolish CLR objects as well as native types (answer at the bottom):
"Download these fixed issues http://www.microsoft.com/downloads/details.aspx?FamilyId=C6C3E9EF-BA29-4A43-8D69-A2BED18FE73C&displaylang=en From Microsoft SQL Server 2008 Feature Pack, August 2008: CLR Types for Microsoft System SQL Server Microsoft SQL Server 2008 Management Objects "