Provisioning sanitized data with SQL Clone and Data Masker. Watch now.

Inject parameters in SQL Scripts For SQLClone

cxc256cxc256 Posts: 3 New member
Is there a way to inject parameters into the SQL Modification scripts for SQLClone when creating images or clones.?Specifically with PowerShell scripting?
Tagged:

Answers

  • Eddie DEddie D Posts: 1,733 Rose Gold 5
    Hi,
    Thank you for your forum post.

    Yes you can make SQL Modifications including the injection of variables, as per this help article.

    The above help article doesn't mention PowerShell, but I believe it maybe possible combine it with PowerShell using the 'new-sqlclonescript' cmdlet as described in this help article

    I recommend you take a look at the two help articles highlighted above as a first step.  Otherwise, we need to know what exactly what you are trying to inject (ideally a copy of the script, you plan to use).

    Many Thanks
    Eddie
    Eddie Davis
    Senior Product Support Engineer
    Redgate Software Ltd
    Email: [email protected]
  • cxc256cxc256 Posts: 3 New member
    That talks about built-in parameters. I want to pass custom parameters as you would any stored proc
  • Eddie DEddie D Posts: 1,733 Rose Gold 5
    Hi,
    Thank you for your reply.

    The method described in the help documents I linked in my previous update are the available options for injecting variables.  There are not any other options available.

    Many Thanks
    Eddie
    Eddie Davis
    Senior Product Support Engineer
    Redgate Software Ltd
    Email: [email protected]
Sign In or Register to comment.