I want from xml feeds that are specific format to create a database that stores all this information.
The xmls have records with specific id's. So the project is about to create database structure according to the structure of the xmls and make a store procedure to save new data from the xmls to the database every 3 hours.
There are 9 xml different formats with different data. In total i calculate about 13-14 tables with 7-8 avg fields per table.