How to Create a snapshot using DLM automation?

10raw · July 18, 2018 9:15PM

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 · July 18, 2018 10:14PM

A database snapshot or a SQL Compare snapshot?

10raw · July 19, 2018 12:37AM

A database snapshot. Thank you for your response.

way0utwest · July 19, 2018 1:46AM

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 · July 19, 2018 2:14AM

thank you for the response

How to Create a snapshot using DLM automation?

Answers

Product Learning

Community Forums

Events & Friends

Simple Talk