I manged to get so far that I can move on to step 3 for my “real problem”-testing-projects.
What is done so far:
- I select needed files from a “List of files” to load them to a second module in the project.
- There I tweak the data as needed until I get to a table which looks exactly like the planned destination table on SQL-Server.
What is missing:
- Delete old data from the destination table on SQL-Server and insert the new data from EasyMorph.
This is where I wonder what would be the best way to do this step 3 “Delete old data from SQL-Server and insert new data” to my project. And as well: Where to add this steps exactly? (Do I need to add them just to the table I will finally load to SQL-Server? Would it possible to seperate that “delete and insert” to another module in the same project [but then how to connect it to the final table]?)
My final tables (different projects) have the following sizes:
IBANPLUS: 17 x 170.000
BLZVZ: 17 x 3.500
Should I use already the more complex BULK LOAD feature of SQL-Server? (New questions: Where to save the temporary CSV-file? and How to use that temp-CSV-File back in the BULK LOAD?