XML to SQL Database

[Scream]

A guy I know is getting a website designed for his store which is nearly completed to sell stock. He now is only thinking about how on earth he is going to get the stock items onto the website fast and easy since there are several hundred or should I say more like several thousand items.

The web designers are just thinking he is putting them on by hand which is stupid when you think of the number of items and they don't seem to care about looking into an alternative method. The business gets its stock from just the one main supplier and after I personally phoned the suppliers last week to discuss ways of doing it, the best they can do is provide an xml file taken from their own website database.

I am going to speak to the web design team about using this xml file but would like some opinions on the use of this xml file and importing or whatever way into a database which I take is an sql database likely mysql but I will have to find that out.

Thanks for any help as the guy has spent several thousand on the site and it could have been a waste of time.

 

[Scream]

Cheers for the info guys.

The guy I know hasn't got back to me regarding his conversation with those making the site for him. I am going to get their number and speak to them myself as they might just tell the site owner that it can't be done.

Like I said earlier there is a good chance they are using mysql but when I get on the phone to them, I will be getting them to change to MSSQL.

I haven't touched Microsoft SQL Server in nearly 8 years since my API development days so I might have to recall on some help if I have to take control of the sites development.

Cheers guys.