we have a three tier environment and i'm trying to move companies from a single tenant to multiple tenant, but when running this command on the NAV server:
HowTo-MoveCompanyToTenant -ServerInstance 'BC140' -FromDatabase 'Demo Database BC (14-0)' -CompanyName 'CRONUS 1.1' -OldTenantName default -NewTenantName CRONUS1 -ServiceAccount 'domainacc' -DatabaseServer 'server1' -RemoveCompanyWhenMoved
I'm getting this error:
Import-SqlPsModule : SQL Server PowerShell cmdlets could not be loaded.
I installed and imported SQLPS on the SQL Server as per:
ModuleType Version Name
----
Manifest 14.0 SQLPS
any help please? thanks!
0