Powershell Import-Module SqlServer and SQLPS dont get along

Question

In a current Powershell session i am running the following commands

Import-Module SqlServer
Import-Module SQLPS

The Import-Module Command for SqlServer works fine, but Import-Module command for SQLPS fails

PS C:\windows\system32> Import-Module SqlServer
PS C:\windows\system32> Import-Module SQLPS
Import-Module : The following error occurred while loading the extended type data file: Error in TypeData
"Microsoft.SqlServer.Management.Smo.NamedSmoObject": The member DefaultKeyPropertySet is already present.
Error in TypeData "Microsoft.SqlServer.Management.Smo.NamedSmoObject": The member DefaultDisplayPropertySet is already
present.
Error in TypeData "Microsoft.SqlServer.Management.Smo.NamedSmoObject": The member DefaultDisplayProperty is already
present.
At line:1 char:1
+ Import-Module SQLPS
+ ~~~~~~~~~~~~~~~~~~~
    + CategoryInfo          : InvalidOperation: (:) [Import-Module], RuntimeException
    + FullyQualifiedErrorId : FormatXmlUpdateException,Microsoft.PowerShell.Commands.ImportModuleCommand

I have tried removing the SqlServer module using Remove-Module command but no luck. I have a script which is Importing the SqlServer module at the start and then there are certain tasks in the script for which the SQLPS module is being used (and it fails with the above error). I am guessing that these 2 modules cannot be loaded in the same powershell session.

Have you tried using the -Force switch on the second Import-Module? Or maybe the -NoClobber switch if that one doesn't work? — TheMadTechnician
– TheMadTechnician, Commented Sep 28, 2020 at 18:38
Yes I added the -Force switch and the -NoClobber switches, it does not work — RAnand
– RAnand, Commented Sep 28, 2020 at 18:47

Brian Reynolds · Accepted Answer · 2020-10-10 18:54:31Z

1

SQLPS is the older version of the SQLServer module and you are correct; the two are incompatible. The SQLServer module is intended to replicate all functionality from the older version, however.

answered Oct 10, 2020 at 18:54

Brian Reynolds

4112 silver badges5 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Powershell Import-Module SqlServer and SQLPS dont get along

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related