Powershell Post with body and windows credentials

Log in as required user.
$params= @{
id=19340;
IsApproved=”true”;
}
Invoke-WebRequest -Method POST -Uri “http://localhost/api/SetSomething” -Body ($params) -UseDefaultCredentials

sql snapshots

CREATE DATABASE mydatabaseSnapshot ON

(

NAME = mydatabase — this is the logical filename – view sql properties for logical name

, FILENAME =   ‘d:\sql\filename.ss’

)

AS SNAPSHOT OF mydatabase;

GO

 

https://docs.microsoft.com/en-us/sql/relational-databases/databases/revert-a-database-to-a-database-snapshot?view=sql-server-2017

 

USE master;

 

RESTORE DATABASE mydatabase

from DATABASE_SNAPSHOT = ‘mydatabaseSnapshot ‘;

GO

SET NOEXEC ON

:setvar Version 1.234

IF (SELECT TOP 1 CONVERT(decimal(5,4),[Version]) FROM [dbo].[Version]) >= $(Version) SET NOEXEC ON;
——- START OF SCRIPT ——–

PRINT N’Adding [dbo].[new_table] …’;

GO
CREATE TABLE [dbo].[new_table](

…

)

CREATE NONCLUSTERED INDEX [IX_new_table_something]
ON [dbo]…..);
GO

 

——- END OF SCRIPT ——–
UPDATE [dbo].[version] SET [version] = ‘$(Version)’
GO
SET NOEXEC OFF;