Inject parameters in SQL Scripts For SQLClone

cxc256 · September 20, 2022 9:19PM

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 · September 23, 2022 9:55AM

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 · October 4, 2022 6:56PM

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

Eddie D · October 7, 2022 3:55PM

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

Inject parameters in SQL Scripts For SQLClone

Answers

Product Learning

Community Forums

Events & Friends

Simple Talk