Log all the migration #3226

4 Answer(s)

• 

  0

  ismcagdas created 7 years ago

  Support Team

  Hi,

  If I understand correctly, you can use -verbose flag with Update-Database command to see runned migration's SQL.

  Save Cancel
• 

  0

  [email protected] created 7 years ago

  Thanks for the reply i need to log all the SQL statments into a log when the Migrator exe is run on production environment so as to check if what all things got fired and to cross check also if everything went well.

  Save Cancel
• 

  0

  ismcagdas created 7 years ago

  Support Team

  Hi,

  Migrator tool does not support this by default. I'm not %100 sure but as far as I remember Entity Framework supports this with some interception but I don't know how to do it. Maybe you can find a solution on the web for this.

  In Migrator tool, we basically call , DbContext.Database.Migrate();

  Thanks.

  Save Cancel
• 

  0

  [email protected] created 7 years ago

  Thanks for the input.

  I am able to log all the DML statements but not the DDL statements.

  Save Cancel