How can we help you today? How can we help you today?

Powershell set up clone and statistics tables.

I'm running a Powershell script to create 2 clones and run masking sets against them.  One database needs to run Cross Database queries and seems to need the statistics tables to run.  How do I create local statistics tables in the automated clone creation?

Thanks a bunch,
Robb
Robb_Keller
0

Comments

4 comments

Sort by
  • Jessica R

    Hi @Robb_Keller, thanks for your post!

    Just to confirm the error, can you please post it here?

    (If it's an error about DMStats missing, I would check that on the server that you are connecting to there is a database called [DMStats] where these statistics can be written, or select the alternative Use Connection DB for Masking Stats Tables.)

    Jessica R
    0
  • Robb_Keller
    I figured out the problem.  There was a type-o in the masking set.  I was also able to run the SQL scripts to create the stats tables in Powershell which also fixed the issue.

    Robb
    Robb_Keller
    0
  • Jessica R
    Awesome, thanks for the update, Robb! So glad you were able to get things working. :)
    Jessica R
    0
  • Robb_Keller
    Also, another issue getting this working was that the server had Powershell set to remote only.  I set it to Unrestricted and all was well.

    Robb
    Robb_Keller
    0

Add comment

Please sign in to leave a comment.