Hello. We read a number of things about referencing SQL Server SMO from Visual Studio but still don't have the definite answers we need. So, here it goes...
A number of years ago we created a C# application using Visual Studio 2005 and SQL Server 2005. In that application, we added .NET references to a number of SQL Server SMO objects, and everything worked fine. Those references were:
Microsoft.SqlServer.ConnectionInfo GAC 18.104.22.168
Microsoft.SqlServer.Smo GAC 22.214.171.124
Microsoft.SqlServer.SqlEnum GAC 126.96.36.199
We have now migrated to Visual Studio 2010 and SQL Server 2008 R2. However, when we try to reference those same SMO objects for SQL Server 2008 R2, they don't appear in the .NET references tab. We're wanting to reference the SQL Server 2008 R2
version of those same SMO assemblies for our upgraded C# application.
On our development machines, we have SQL Server 2008 R2 Developer installed with all options, including the SDK such that the assemblies are found in C:\Program Files (x86)\Microsoft SQL Server\100\SDK\Assemblies.
So, my first questions are: Are we supposed to do file references to the SMO assemblies instead
View Complete Post