Hi,
I am a Full stack developer in Microsoft technologies.
I understand that you are looking for a solution that picks data from XML files and imports into sql server.
I propose the same to be done in two ways, one through console application, another through windows app. Based on your choice either of these can be done. On the performance front, depending on the size of the XML file and the total size of db on SQL server, we can use different methods of import that is supported by SQL server.
I am pretty confident about providing you an optimal solution.
My area of expertise is web application development (asp.Net web forms, MVC, classic ASP), web services (SOAP & RESTFul), MySql & Sql Server as back end (through stored procedures).
I have 6 years of experience as a full time software developer.
Kindly contact me, lets discuss your requirements.