Scripts not running/ or not in order?

• 
  I guess I should say that the baseline script is the first script in the Migrations folder as folder 1.0.0-Baseline with just that one item.

  Mij September 13, 2021 20:05

  - 0 +
• 
  Hi @Mij
  
  Can I double-check the database you're executing the scripts against, is it completely empty?
  
  The baseline won't be executed if there are existing objects in the database.

  DanC September 15, 2021 09:58

  - 0 +
• 
  As I said, I freshly dropped and created the database and then I tried to run the scripts.  What else would you be looking for?  If there are gMSA accounts or users that somehow came back, would that affect it?  I haven't added anything to the database after I recreated it.

  Mij September 15, 2021 12:09

  - 0 +
• 
  Hi @Mij
  
  Can I ask how you're executing these? are you using PowerShell and executing the project against the target database?
  
  You could try modifying my script here and this will output all the debug information as it tries to run the operation:
  
  

  $DebugPreference= 'Continue'

  $VerbosePreference= 'Continue'

   

  $project = "C:\Users\Dan.Calver\Downloads\Ticket_162740\AzureDatabase\AzureDatabase.sqlproj"

   

  $temporaryDatabase = New-DatabaseConnection -ServerInstance "PS-DANC\DC_SQL2019" -Database "TemporaryDb1"

   

  $Target = New-DatabaseConnection -ServerInstance "PS-DANC\DC_SQL2019" -Database "AzureDatabase"

  
  

  $validatedProject = $project | Invoke-DatabaseBuild -TemporaryDatabase $temporaryDatabase

  
  

  $databasePackage = $validatedProject | New-DatabaseBuildArtifact -PackageId 9999 -PackageVersion 1.0.0

   

  $databasePackage | Export-DatabaseBuildArtifact -Path "c:\Packages"

   

  $package = "C:\Packages\9999.1.0.0.nupkg"

   

  $update = New-DatabaseReleaseArtifact -Source $package -Target $Target

   

  Use-DatabaseReleaseArtifact $update -DeployTo $Target

  DanC September 15, 2021 12:20

  - 0 +
• 
  I haven't used Powershell.   I'd have to see what to do with this.  Basically, I open SSMS, drop the database, recreate the database, and then open the SCA project and see that there are 20 scripts to be applied.  I click the "Apply/All" button.  It errors on the later migrations because the baseline has not run to populate with tables and objects even though that is the first migration script.

  Mij September 15, 2021 12:48

  - 0 +
• 
  Thank you for you quick responses though.

  Mij September 15, 2021 12:52

  - 0 +
• 

  Mij said:

  I haven't used Powershell.   I'd have to see what to do with this.  Basically, I open SSMS, drop the database, recreate the database, and then open the SCA project and see that there are 20 scripts to be applied.  I click the "Apply/All" button.  It errors on the later migrations because the baseline has not run to populate with tables and objects even though that is the first migration script.

  Ah, that makes more sense, apologies was trying to wrap my head around how you were performing this task!
  
  I haven't actually tested this behaviour, so I'm going to try this myself and perhaps query the devs, I'll let you know once I have more details!

  DanC September 16, 2021 07:53

  - 0 +
• 
  Hi @Mij
  
  If it's okay, I'm going to reach out via a support ticket as the developers have asked for the project to review and see what's going on!

  DanC September 16, 2021 08:28

  - 0 +

Add comment

Please sign in to leave a comment.