an application that will work regardless of SQL server version

Hello !

Is there a way to make an application that use SMO libraries , to work regardless of SQL server version ?

I'm referencing the SMO libraries from version  2008R2 , but when I use my application with sql server 2005 or 2012 , doesn't work.

Is there any solution ?

Thank you !

May 27th, 2015 5:34pm

References to SMO dlls in older versions of SQL Server must be removed, and references to the new SMO dlls that are provided with SQL Server 2014 must be included.

Minimally, you would reference the following:

  • Microsoft.SqlServer.ConnectionInfo

  • Microsoft.SqlServer.Smo

  • Microsoft.SqlServer.Management.Sdk.Sfc

These files are required for connection classes, SMO utility classes, and foundation classes.

https://msdn.microsoft.com/en-us/library/dd206977.aspx?f=255&MSPPError=-2147217396

Free Windows Admin Tool Kit Click here and download it now
May 27th, 2015 10:16pm

References to SMO dlls in older versions of SQL Server must be removed, and references to the new SMO dlls that are provided with SQL Server 2014 must be included.

Minimally, you would reference the following:

  • Microsoft.SqlServer.ConnectionInfo

  • Microsoft.SqlServer.Smo

  • Microsoft.SqlServer.Management.Sdk.Sfc

These files are required for connection classes, SMO utility classes, and foundation classes.

https://msdn.microsoft.com/en-us/library/dd206977.aspx?f=255&MSPPError=-2147217396

So if I reference the new SMO 2014 files , my application will work with all version of sql server  ? ( version 2005-2014) ? Is this correct ? All the SMO functions will work with any sql server version ?

Thank you !

May 27th, 2015 10:32pm

Hello,

SMO is backward compatible over several version, but not over all. Yes, SMO for SQL Server 2014 will work with SQL Server 2005, but not with e.g. 2000.

Free Windows Admin Tool Kit Click here and download it now
May 28th, 2015 3:22am

Hello,

SMO is backward compatible over several version, but not over all. Yes, SMO for SQL Server 2014 will work with SQL Server 2005, but not with e.g.

May 28th, 2015 3:39am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics