Generating Db Versions

Question

Hi, I am trying to generate 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 receive 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.

Please guide me a little that How I can resolve this issue

Answer 1

Yes I have Installed Sql Server Management Studio

Answer 2

I'm going to guess you're using SQL 2008? Have a look here: http://msdn.microsoft.com/en-us/library/cc284267.aspx

You need to pull down the CLR objects as well as Native types (the answer is at the bottom):

"Downloading these resolved the issue http://www.microsoft.com/downloads/details.aspx?FamilyId=C6C3E9EF-BA29-4A43-8D69-A2BED18FE73C&displaylang=en From Microsoft SQL Server 2008 Feature Pack, August 2008: Microsoft SQL Server System CLR Types Microsoft SQL Server 2008 Management Objects "

Answer 3

Hi Rob Conery, Thanks for the solution, Now it is fixed and I am able to generate Db Version.

Regards, Muhammad Naveed Khan