Powershell set up clone and statistics tables.

Robb_KellerRobb_Keller Posts: 21 Bronze 1
in SQL Clone
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
Tagged:
· Share on Twitter

Answers

  • Jessica RJessica R Posts: 1,319 Rose Gold 4

    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 Ramos | Product Support Engineer | Redgate Software

    Have you visited our Help Center?


    · Share on Twitter
  • Robb_KellerRobb_Keller Posts: 21 Bronze 1
    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
    · Share on Twitter
  • Jessica RJessica R Posts: 1,319 Rose Gold 4
    Awesome, thanks for the update, Robb! So glad you were able to get things working. :)

    Jessica Ramos | Product Support Engineer | Redgate Software

    Have you visited our Help Center?


    · Share on Twitter
  • Robb_KellerRobb_Keller Posts: 21 Bronze 1
    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
    · Share on Twitter
Sign In or Register to comment.