Renaming files under Scripts folder in dbops repository

[darshmur]

Currently we rename the filename with .sql extension if there are any changes into it and we want it to be deployed to destination sql server database.
If we dont rename it, the changes do not reflect after deployment, because the file is matched with the content of SchemaVersions table which maintains the records of already executed files and it does not rerun. Can you please suggest any recommeneded approach so that we dont need to rename the filename if there are any changes into its contents.

We are currently using 0.6.4 and upgrading it to 0.9.1 versions of dbops module. The structure of SchemaVersions table has been changed from 0.6.4 to 0.9.1 versions of dbops. However, when we switch from 0.6.4 to 0.9.1 in existing database for deployment, then the structure of this table remains same.

Currently we are using following commands to create the package:
New-DBOPackage -Path C:\Temp\DummyRepo.zip -Build DummyRepo -ScriptPath C:\Repos\DummyRepo\Scripts -Match .*.sql -force -PreScriptPath C:\Repos\DummyRepo\Prescripts -PostScriptPath C:\Repos\DummyRepo\Postscripts

And using following command to deploy it:
Install-DBOPackage -Path C:\Temp\DummyRepo.zip -SqlInstance .\sql2019 -Database DummyDB1 -CreateDatabase -Verbose

[nvarscar]

1. For your changing filenames, I recommend to look into using Add-DboBuild -Type New, Modified, which should add another build to the package that would include the files modified since last run. Then you should be able to deploy it on top of the previous package build in the same way.
2. Update-DBOSchemaTable was created to upgrade your SchemaVersions table to contain the new columns. Since this behavour would break backwards compatibility with previous versions, you need to "opt in" by using this function.