create database if not exists

• abdalah.mehdoini

  Ten Centuries

  Points: 1023

  More actions

  April 19, 2020 at 5:47 pm

  #3744016

  Good morning all

  I am looking to create a sql server database if the database does not exist on my instance

  I use this script for this

  Import-Module "SQLPS" -DisableNameChecking
  Import-Module -Name "${PSScriptRoot}\Module\logModule.psm1" -DisableNameChecking
  Add-Type -AssemblyName "Microsoft.SqlServer.Smo"
  $servers= 'DESKTOP-95KKMMH\PRODUCTION','DESKTOP-95KKMMH'
  $database='produit'
   
  foreach($server in $servers)
  {
  Set-Location SQLSERVER:\SQL\$server 
  $db = New-Object -TypeName Microsoft.SqlServer.Management.Smo.Database -Argumentlist $server, $database
  
  if($db -ne $null)
  {
  $db.Create()  
  }
  else 
  {
  InitLog -PathLog "${PSScriptRoot}\${Instance}\DbaWhoIsActive.log" -NameScript "PsBackupFull"
  Log -message "Server : ${$server}"
  Install-DbaWhoIsActive -SqlInstance $server -Database $database
  }
  }

   

  attached the error that I have if the base exists

  

   

  thanks for your help

   

• John Mitchell-245523

  SSC Guru

  Points: 148809

  More actions

  April 20, 2020 at 10:57 am

  #3744543

  Your New-Object command is running before you've done any existence check.  If the database already exists then you'll get an error.

  John