SAPIEN Technologies

Product, version and build: SAPIEN Software Suite 2017
32 or 64 bit version of product: 64 bit
Operating system: Windows 10
32 or 64 bit OS: 64 bit

In conjunction with a new project, I need to update my Suite 2017 to 2018.
What would it cost me to do such an upgrade if at all possible?

Thank you.

Importing the dll in the proposed manner worked.
But since transcription is not possible when compiled, we have to continue running it as a script in STA mode.

Thank you for the information, I did not even think that transcription was not available in WHv2. I am more leaning towards your suspicions regarding the snap-ins not working in Windows Forms Host. I have not attempted to load the dll as you suggested, I will attempt that once I am back in the offic...

2 error scenarios that I have experienced with the STA depending on how the script is formulated. 1) Transcription fails ( an output that gets manipulated later) Start-Transcript : This host does not support transcription. Used to retrieve the output of a T-query on the SQL 2008r2 servers, some sql ...

Same error with the 32 bits as well.

My mistake, my attempt with the snapshot was to show you the STA setting configuration that I have chosen.
I have also chosen the correct "Windows Forms Hosts" and it does not work, it fails.

I thought I did, attached a snapshot of the settings.

Upgrading the PowerShell on 100+ servers is not an option at this point in time since they are being migrated and phased out. For those servers, the SQLPS cannot be imported as a module and the need for the snapins arises. So I conclude from our discussion that either an upgrade or to continue using...

SQLPS as an imported module is only supported in SQL 2012 or newer.
In 2008R2 versions it cannot be imported as a module, it is only a host, hence the need to add the pssnapins for certain operations.

Thanks for that tip, but that will not work in this case.
I forgot to mention, the script checks the SQL version, if the SQL cluster is running a 2012 or newer, SQLPS is imported, but if the SQL is an older version then the pssnapins are added.