Basically there are many huge delimited files that I know I can import as a table, but I need to map this data to an existing rational MySQL table with multiple tables. There should not be any conflict with data types, but I'm super new to this, so please point out everything that I should observe. It is clear that I will not run this in the production process until I find out that it works.
Not 100% sure stackoverflow is the right place to ask a question about the database, but I could not find another Stack Exchange package that would be better suited.
Submitted a question on SuperUser, looking for a GUI to do this, but for coding it, it does its job. As such, there is no target language, just a requirement that the database be MySQL.
Also, I found this stackoverflow Q / A file, which is related to MSIS SQL SSIS (which I do not plan to use because of the cost, but the contents and problems they encounter are of the same nature). -
Download multiple tables using SSIS with saving foreign keys
source
share