Plans to add a New-DatabaseMigration cmdlet?

• 
  What IDE are you using to make your database changes? We sort of assume that this is where most people would want to trigger the action to create a migration script. Are we wrong?

  David Atkinson June 05, 2020 14:57

  - 0 +
• 
  I used to use the VS plugin.  Now, mostly the SSMS plugin.  I imagine most work will still occur in the UI.  However, I would also find value in being able to automate.  For example, i could write a powershell script that adds a column, updates a sproc to use that column, gens the migration, and commits the code, triggering a CI/CD process.  Just a nice-to-have.
  

  PeterDanielsCRB June 05, 2020 15:06

  - 0 +
• 
  Oh - and sometimes, I will use a round-trip data modeling tool (e.g. dbschema) for the schema mods.

  PeterDanielsCRB June 05, 2020 15:07

  - 0 +
• 
  What would this cmdlet look like (eg a sample invocation with switches etc)

  David Atkinson June 05, 2020 15:18

  - 0 +
• 
  Good question.  Maybe something like:
  
  $sourceDB = New-DatabaseConnection [...]
  New-DatabaseMigration -InputObject <PathToSqlProjectFile> -Source $sourceDB
  
  Source DB could also be the default dev DB from the sql proj file.  It would behave similar to the process that happens in SSMS when we "generate migration(s)".

  PeterDanielsCRB June 09, 2020 18:57

  - 0 +

Add comment

Please sign in to leave a comment.