How to Create a snapshot using DLM automation?

10raw

Hi,

I was wondering if there is any way ( either by using powershell cmdlets or using Jenkins plugin) to create a snapshot of a database in Jenkins job.

Thank you

way0utwest

A database snapshot or a SQL Compare snapshot?

10raw

A database snapshot. Thank you for your response.

way0utwest

This would not be a DLM function, but just a T-SQL call. You could use a SQLCMD step in your build/release tool, or a PoSh step, and call the CREATE DATABASE AS SNAPSHOT OF command.

10raw

thank you for the response