Hi there, here in the company we have applications in access, fox pro, oracle, mysql, excel, etc, etc.
In order to create one big database, what would be the best strategy ?
assuming the final database is for example mysql.
would be to re-code all the applications ?
or only change their tables now to point to the final database.
There are a few thousand options. You have to pick the one that makes the most sense for your organization.
Just as an observation, many of the databases you are converting from are more powerful (syntactically more expressive if you want to be picky about it) than MySQL is, so you've got quite a task ahead of you!