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 188.8.131.52
Microsoft.SqlServer.Smo GAC 184.108.40.206
Microsoft.SqlServer.SqlEnum GAC 220.127.116.11
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