Inject parameters in SQL Scripts For SQLClone

cxc256

Is there a way to inject parameters into the SQL Modification scripts for SQLClone when creating images or clones.?Specifically with PowerShell scripting?

Eddie D

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

cxc256

That talks about built-in parameters. I want to pass custom parameters as you would any stored proc

Eddie D

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