Data base automation.

[prasadgp]

This node falls below the community's threshold of quality. You may see it by logging in.

[hippo]

Hello, prasadgp. Which part in particular is giving you trouble? What code have you written already? In what way does it fail to meet your requirements?

[stevieb]

Please re-frame your question with what you've tried, what errors you're getting, and what your desired output is.

[Anonymous Monk]

Heheh :) OP is looking for files, said look for modified upgrade and downgrade files and execute the downgrade scripts

perlintro, File::Find::Rule/Path::Tiny, system, Capture::Tiny

[erix]

What does "upgrade" and "downgrade" mean here?

[Laurent_R]

Hmm, when you say upgrade and downgrade, do you mean perhaps upload and download? Please explain.

[Anonymous Monk]

In case of Sybase ASE, after installing a new version, commands are run to upgrade/update the table structure, (rebuild) index, change/add system functions, etc. I hadn't tried to downgrade, so I can't comment on that aspect.

[runrig]

Here's some pseudo-code for you:

my @downgrade_scripts = find_downgrade_scripts();
for my $script (@downgrade_scripts) {
  run_script($script);
}
my @upgrade_scripts = find_upgrade_scripts();
for my $script (@upgrade_scripts) {
  run_script($script);
}