I've just migrated to Visual Studio 2010 and have found it strange to reference SQL 2005 SMO. Under VS2008, add reference dialog will show GAC in .NET tab. After installing VS2010, SQL 2008 SMO are also installed, and I saw two sets of SMO in GAC with
version of 9.0 and 10.0. That's good.
But when I open my project, VS 2010 told me that all is wrong. By using add reference dialog, I found no SMO objects in .NET tab. So I browse for dll files under c:\program files\microsoft sql server\90\SDK .... It will not work well since the project file
will record relative path. After moving my project, I must repeat this. Why can't I find 2005 SMO in this dialog?
I can understand that SMO for 2008 is not there. My project is a .NET 2.0 one and maybe SQL 2008 does not support .NET 2.0. But 2005 do. I can see it in GAC but cannot reference it from VS2010.
Hope I've described clearly. Thanks for help!
View Complete Post