I was able to resolve the issue.

I had to use $env variable for this to work.

$databaseinput=$env:DATABASENAME

$sqlpassword=$evn:DBPASSWORD

$buildnumber=$env:BUILD_BUILDNUMBER

Thank you

Hi Jeff,

Thanks for your reply. The script i included here is just a part of the long script. I did not see any other way to achieve what i was...

do you mean this way? -:

[CmdletBinding()]

param (

$($databasename),

$($dbpassword),

$($buildnumber)

)

1. $(databasename), and $(dbpassword) are defined in pipeline variables. I wanted to use that in the powershell script thats why the parenthesis around them
2. $(build.buildnumber) - I have used it...

Hi Phil,

In my release pipeline i am trying to run the powershell script using "File path". In the arguments section i have passed what was defined in the variables section...

Hi Phil,

That worked like a charm. Thank you so much, really appreciate that.

So, when i used $dbname instead of Master, does it assume that the database should exist? is that...

Thank you for your reply Phil.

Yes, i am using master as default. below is the code -:

$sql = @"

USE [master]

RESTORE DATABASE $dbname FROM DISK = N'$fullpath' WITH FILE = 1,...

Thanks Brian.

Both Azure SQL and SQL MI are restricted by IP addresses in our Network Security Group but like you said it will still be a good practice to implement...

Thank you very much for your reply Brian.

you made the case perfectly with an apt explanation for every scenario. Appreciate your reply.

Thank you again

Hi @frederico, Thank you, so to fulfill that request to get the data from data pages, can you please provide me some insight and/or documentation to how I can actually...

Thanks @frederico, but wouldn't the data pages keep on changing every time we run index reorg or index rebuild?

I agree @ken and @kristen

But is it even possible to get the first 25 and last 25 pages of data from the data pages since Data pages constantly keeps moving...

• This reply was modified 4 years, 6 months ago by MillionQueries.

Thank you @steve-2, Appreciate your help

I have already done the restore using the URL by manually using the Restore commands mentioned in this article, however I am looking to automate...

Thanks for your message @steve-2.

I need this script for a Data Migration project from Azure VM to Azure SQL MI.

I already have a backup script which directly backs up 10...

Thank you very much for your reply Lowell. I appreciate it.

Thank you again.