Data base automation.

prasadgp has asked for the wisdom of the Perl Monks concerning the following question:

Replies are listed 'Best First'.
Re: Data base automation. by hippo (Archbishop) on Nov 04, 2015 at 23:28 UTC
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?	[reply]
Re: Data base automation. by stevieb (Canon) on Nov 05, 2015 at 01:41 UTC
Please re-frame your question with what you've tried, what errors you're getting, and what your desired output is.	[reply]
Re: Data base automation. by Anonymous Monk on Nov 05, 2015 at 08:12 UTC
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	[reply]
Re: Data base automation. by erix (Prior) on Nov 05, 2015 at 07:29 UTC
What does "upgrade" and "downgrade" mean here?	[reply]
Re: Data base automation. by Laurent_R (Canon) on Nov 05, 2015 at 08:09 UTC
Hmm, when you say upgrade and downgrade, do you mean perhaps upload and download? Please explain.	[reply]
Re^2: Data base automation. by Anonymous Monk on Nov 05, 2015 at 17:45 UTC
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.	[reply]
Re: Data base automation. by runrig (Abbot) on Nov 05, 2015 at 18:18 UTC
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); }` [download]	[reply] [d/l]