I have a MySQL database and I would like to understand the best mechanism to do the following:
1) Export data from MySQL (already a database dump is being generated)
2) Schedule an import of this MySQL Database (import)
3) Do a delta load (so that I am not every night loading the whole database)
4) Run standardized scripts to modify and then output the calculated results (for consumption of a business intelligence tool that I am setting up).
I guess one consideration here is whether I import the database into MySQL or just the data dumps.
I will most likely give this job to a contractor as I know it's very easy - I just don't want to spend a long time troubleshooting. I want to know what is required to be done with some idea technically how this will be done. Would appreciate some details - e.g. if you advise where in the SQL Server Studio tool this is done.