| Author | Brandon Abshire, netnerds.net |
| Availability | Windows, Linux, macOS |
Want to see the source code for this command? Check out Get-DbaDbFeatureUsage on GitHub.
Want to see the Bill Of Health for this command? Check out Get-DbaDbFeatureUsage.
Identifies Enterprise-edition features currently used in databases that prevent downgrading to Standard edition
Queries the sys.dm_db_persisted_sku_features dynamic management view to identify SQL Server Enterprise features that are actively used in your databases. This is essential when planning to downgrade from Enterprise to Standard edition or migrating databases to environments with lower SQL Server editions.
Enterprise features like columnstore indexes, table partitioning, or transparent data encryption must be removed or disabled before a database can be successfully migrated to Standard edition. This function helps you inventory these blocking features across one or more databases so you can plan the necessary remediation steps.
Returns feature ID, feature name, and database information for each Enterprise feature found, making it easy to identify which databases need attention before edition changes.
Get-DbaDbFeatureUsage
[[-SqlInstance] <DbaInstanceParameter[]>]
[[-SqlCredential] <PSCredential>]
[[-Database] <String[]>]
[[-ExcludeDatabase] <String[]>]
[[-InputObject] <Database[]>]
[-EnableException]
[<CommonParameters>]
PS C:\> Get-DbaDatabase -SqlInstance sql2008 -Database testdb, db2 | Get-DbaDbFeatureUsage
Shows features that are enabled in the testdb and db2 databases but
not supported on the all the editions of SQL Server.
The target SQL Server instance
| Alias | |
| Required | False |
| Pipeline | false |
| Default Value |
Login to the target instance using alternative credentials. Accepts PowerShell credentials (Get-Credential).
Windows Authentication, SQL Server Authentication, Active Directory - Password, and Active Directory - Integrated are all supported.
For MFA support, please use Connect-DbaInstance.
| Alias | |
| Required | False |
| Pipeline | false |
| Default Value |
Specifies which databases to scan for Enterprise edition features. Accepts wildcards for pattern matching.
Use this when you need to check specific databases instead of scanning all databases on the instance.
Helpful when planning edition downgrades for particular databases or troubleshooting feature usage in development environments.
| Alias | |
| Required | False |
| Pipeline | false |
| Default Value |
Excludes specific databases from the Enterprise feature scan. Accepts wildcards for pattern matching.
Use this to skip system databases, read-only databases, or databases you know don't need to be downgraded.
Commonly used to exclude tempdb, model, or archived databases from bulk scanning operations.
| Alias | |
| Required | False |
| Pipeline | false |
| Default Value |
Accepts database objects directly from the pipeline, typically from Get-DbaDatabase output.
Use this for advanced filtering scenarios or when you've already retrieved specific database objects.
Allows you to chain database selection commands with feature usage checking in a single pipeline operation.
| Alias | |
| Required | False |
| Pipeline | true (ByValue) |
| Default Value |
By default, when something goes wrong we try to catch it, interpret it and give you a friendly warning message.
This avoids overwhelming you with "sea of red" exceptions, but is inconvenient because it basically disables advanced scripting.
Using this switch turns this "nice by default" feature off and enables you to catch exceptions with your own try/catch.
| Alias | |
| Required | False |
| Pipeline | false |
| Default Value | False |