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.
this will cover steps 1 2 and 3 more information is needed for 4
first download the correct connector from the link below from (suggest MySQL ODBC Connector 5.1)
MySQL ODBC Connector (http://dev.mysql.com/downloads/connector/)
More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.