Microsoft.SqlServer.Management.Smo.Server class compatibility among different SQL Server versions
Here is my question: I have a server running SQL Server 2008 R2 (SP3) and I'm trying to create a PowerShell script to perform some administrative tasks.
This PowerShell script uses a method called EnumServerPermissions on the class Microsoft.SqlServer.Management.Smo. According to the official MS documentation on this method this is only supported on SQL Server 2012 onwards.
Now my question is this: since this class lives inside Microsoft.SqlServer.Smo.dll, isn't there a way to run an updated version of the SQL Server Management Objetcs (SMO) that is compatible with this method call, even on an older version of SQL Server (such as my 2008 R2)? Do I have to accept this just doesn't run on my version? Or is there a way to make it work by updating something?
Thanks!
If you are saying that Microsoft documentation is stating it only supports SQL Server 2012 + because of this:
That would be incorrect, and not officially stating what version it supports and doesn't support. SMO is treated just like SQL Server Management Studio. You can utilize a new version to connect to any version of SQL Server. The only stipulation is certain properties or classes would fail based on the property not existing on lower versions of SQL Server or feature is not available (e.g. AvailabilityGroup namespace on SQL Server 2008 R2 would fail).
As an example, in the PowerShell module dbatools we have the latest version of SMO packaged with that module. So if you installed that module on a brand new machine you could connect to any version of SQL Server, from 2000+. We have commands in that module that support running against SQL Server 2000 and then some that only for 2012+ version of SQL Server.
- migrate data from MS SQL to PostgreSQL?
- Sqoop Import HBase - SQL Database
- How important is the order of columns in indexes?
- Connect to SQL Server running on Windows host from a WSL 2/Ubuntu sqlcmd
- SQL Server, to normalize this much or not?
- Strange behavior of symfony doctrine during phpunit test - field becomes null in database
- How do I make it to where my login will accept either an email or username in the username field
- Adding column to select statement in SQL causes timeout
- SQL Server: Clustered index on datetime, ASC or DESC
- SQL Pivot on Conditional Count
- SQL Server indexes - ascending or descending, what difference does it make?
- Query to concatenate row data in each group
- Combine 2 SQL Statements
- Converting SQL server timestamp to an epoch timestamp
- Change Date format from yyyy-mm-dd to mm/dd/yyyy Derived Column
- How do you send email with TSQL using a Agent Operator instead of an email address?
- Spark sending LIMIT to SQL Server on display function
- How can I manage Azure SQL user/login/credentials
- Can't add members to SSAS role through Visual Studio
- How to use Charindex for one or the other character
- SQL want to calculate time hours and mints of each emp
- Incorrect Syntax near ',' in SQL query execution in Spring JPA but executes successfully in database
- How to make multiple select into on the same table?
- Invoking a stored procedure with all combinations of values stored in multiple single-column tables
- Get Value From Json object contain table column using SQL Query
- Compute count(*) of unique occurrences into new column without group by in a single select query
- Is there any better option to apply pagination without applying OFFSET in SQL Server?
- How to get a list of tables with composite primary key in SQL Server?
- Calculating churn rate in SQL: how can I display both churned and not churned customer in % in a single query?
- How can you tell what Tables are taking up the most space in a SQL Server 2005 Database?