List of scripts deployed script

General Discussion
1

We are using Liquibase for deployment of scripts on SQL Server.
is there any way to get the list of scripts that are successfully deployed and list of failed scripts(along with the reason for failure)

2

Liquibase creates two tables for tracking changes: DATABASECHANGELOG and DATABASECHANGELOGLOCK. You can simply do a SELECT * FROM DATABASECHANGELOG; after your Liquibase run. In fact, we include a full dump of that table in all of our Liquibase CI jobs so we can see proof it ran.

Please see the following documentation:

3

As far as I know, the only place failed scripts are reported is in the output from the Liquibase execution. The databasechangelog will only contain successful changesets.

4

Thanks for reply.
In DATABASECHANGELOG table in

  1. FileName column it displays changeset filename (eg chg1.xml or chg2,xml). This changeset file has the list of .sql file that needs to be deployed.
  2. In Description file it is displays .sqlfile,.sqlfile. But not displaying the .sql filename which is failed.

Can we get this information any where.??

Also, is there any way where I can find the list of .sql files that are successfully deployed for the Particular changeset.

Also,

“As far as I know, the only place failed scripts are reported is in the output from the Liquibase execution. The databasechangelog will only contain successful changesets.”
Where I can find the “output from the Liquibase execution”

All the above requirement is holding us back to move to Liquibase. As the developers are not sure which scripts are deployed and which script are failed along with the reason.

5

The databasechangelog table is not intended to record “deployment attempts”. It is a record of successfully deployed changesets. You need to interpret the output from Liquibase CLI to determine what changes have errors. The output from Liquibase is provided immediately upon execution.

Your developers can determine which scripts have been deployed by looking in the databasechangelog table.