Jump to content

xml to other database conversion

dbcrawler's Photo
Posted Jan 12 2010 06:57 AM
2654 Views

Can xml form of data can be converted to other databases and vice versa???.

I m doin a project on conversion of databases to xml and xml to other databases using C# ... Help for that...

Tags:
0 Subscribe


1 Reply

0
  todisht's Photo
Posted Feb 18 2010 07:31 PM

You should be able to write a function to loop through your XML and insert each record into your database. Likewise you can take a dataset that you receive from your database and convert it to XML. I believe C# even has a method that will do this for you.

Another option if you are using a MS SQL database would be to create SSIS jobs to directly import your XML files into the database.