How to create dynamic powershell query?

Question

I have a Powershell query to get the backup of my database. But i need to have the backup the data with different names like DATABASEBACKUP_CURRENTDATE. How can i achieve this?

./RedGate.SQLAzureBackupCommandLine.exe /as: AzureServerNAME/ad: AzureDatabaseName    /au:AzureUserName /ap:AzurePassword /cc /s /ls:. /ld:LOCALDATABASENAME_CURRENTDATE /dl /v /ba

vonPryz · Accepted Answer · 2012-01-13T07:45:53.407

0

First, build a string that contains the current date:

$backupName = $("Backup-{0}" -f [DateTime]::Now.ToString("yyyy-MM-dd"))

Then call RedGate and use the date string as a parameter:

./RedGate.SQLAzureBackupCommandLine.exe /as: AzureServerNAME /ad: AzureDatabaseName /au:AzureUserName /ap:AzurePassword /cc /s /ls:. /ld:$backupName /dl /v /ba

Ed: Copypaste/markup messed with brackets and colons, fixed 'em.

edited Jan 13 '12 at 07:45

answered Jan 13 '12 at 05:17

vonPryz

22,996
7
54
65

When i am trying to create the string i am getting error on Now.ToString("yyyy-MM-dd"). You must provide a value expression on the right-hand side of the '-f' operator. At line:1 char:32 + $backupName = $("Backup-{0}" -f <<<< Now.ToString("yyyy-MM-dd")) + CategoryInfo : ParserError: (:) [], ParentContainsErrorRecordException + FullyQualifiedErrorId : ExpectedValueExpression – Balraj Singh Jan 13 '12 at 05:29

score 0 · Answer 2 · answered Jan 13 '12 at 05:47

0

To get a string constructed with the current date, you can simply do:

"DATABASEBACKUP_{0:MM-dd-yyyy}" -f [DateTime]::Now

It will give something like DATABASEBACKUP_01-12-2012. You can use that as arguments as needed

answered Jan 13 '12 at 05:47

manojlds

290,304
63
469
417

score 0 · Answer 3 · answered Jan 13 '12 at 07:22

0

Throwing in another solution...

"DATABASEBACKUP_$(Get-Date -Format MM-dd-yyyy)"

answered Jan 13 '12 at 07:22

Tom

1,611
1
13
16

How to create dynamic powershell query?

3 Answers3