How do I create temporary SQL Clone databases in C# for automated unit tests?

TimHaston

I have an SQL Clone image. I want to use to run automated unit tests against a temporary version of that image just for the duration of the unit test. There could be multiple unit tests running in parallel during CI so I want the temporary version to be unique. I want to do this in C#. I haven't seen this described in the articles - would I use SCA or just SQL Clone, or some other tool? 

Kurt_M

Hi @TimHaston,

It sounds like you would want to make use of SQL Change Automation for the testing you've described. SQL Clone can create the image of course, and then you can create the pipeline through something like azure devops tied in with an SQL Change Automation project.