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/)
Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!
Does the idea of dealing with bits scare or confuse you? Does it seem like a waste of time in an age where we all have terabytes of storage? If so, you're missing out on one of the core tools in every professional programmer's toolbox. Learn how to …