Sign in
 
Home20122008 R2200820052000LibraryForums
SQL Server >
> 
> 
Deploy .NET 4.0 framework assemblies in SQL Server 2008 SP1

Answered Deploy .NET 4.0 framework assemblies in SQL Server 2008 SP1

  • Tuesday, May 15, 2012 7:36 AM
     
     
    Sign In to Vote
    0

    There is are requirement of deploying .NET 4.0 library to SQL Server SP1.

    This requirement is arised because, recently the library which needs to be deployed is migrated to .NET 4.0 from 2.0 assembly and after migrating from 2.0 to 4.0 the problem occurs.

    Is ther a way/workaround such that .NET 4.0 assembly can be deployed to SQL Server 2008 SP1.

    Version of SQL:

    Microsoft SQL Server 2008 (SP1) - 10.0.2531.0 (Intel X86)   Mar 29 2009 10:27:29   Copyright (c) 1988-2008 Microsoft Corporation  Standard Edition on Windows NT 5.2 <X86> (Build 3790: Service Pack 2).

    I looked into related posts, but they specified that SQL Server 2008 Express with SP1 is shipped supporting the requirement. Can please let me know is there any workaround for standard version also???

    Thanks in advance.

    --Lakshman

     

All Replies

  • Tuesday, May 15, 2012 8:42 AM
     
     Answered
    Sign In to Vote
    0

    SQL Server 2008 (R1 and R2) only supports CLR assemblies up to .NET Framework 3.5, whereas SQL 2012 supports .NET Framework 4.

     
  • Tuesday, May 15, 2012 9:05 AM
     
     
    Sign In to Vote
    0

    Thanks andrieso,

    So there is no way in using the .NET 4.0 libraries.

    --Lakshman

     
  • Wednesday, May 16, 2012 7:58 AM
    Moderator
     
     
    Sign In to Vote
    0

    Hi Lakshman,

    This article on the SQL Server Express blog suggests there will be no .NET 4 SQLCLR in SQL Server 2008 (assuming that the logic extends to the other editions).

    Please see: http://blogs.msdn.com/sqlexpress/archive/2009/12/09/sql-server-express-and-net-4.aspx

    Best Regards,
    Iric
    Please remember to mark the replies as answers if they help and unmark them if they provide no help.