What are the challenges you face when working across database platforms? Take the survey

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

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? 


  • Options
    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.

    Kind regards,

    Kurt McCormick
    Product Support Engineer, Redgate

    Need help? Take a look at our Help Center

Sign In or Register to comment.