can I exchange data between Sql server and oracledatabase via Xml [Archive]

Click to See Complete Forum and Search --> : can I exchange data between Sql server and oracledatabase via Xml

Reham

01-15-2003, 04:16 AM

hi everyone?

Can I use Xml File to export a table from a database and then import this to oracle database/

is this possible? please advice

and can xml transfer data from windows to linux oe mac

oleaseadvice?

Robert Wellock

01-15-2003, 05:59 AM

I don't quite know what you mean by transfer; but if mean can Oracle interpret eXtensible Markup Language (XML) then I'd say yes since XML 1.0 is platform independent; http://www.w3.org/

khalidali63

01-16-2003, 09:34 AM

Yes XML is paltform independent and hence you should not have any problems using it on windows,linux/unix or on mac Os,I know that oracle does have an XML parser bundled up with there8+ versions and from your question its not clear what exacly you mean by transfer,
if you meant that you have a table in xml format and will oracle read it and create a table accordingly,I'd guess so,since Oracle corp is amongst those who pushed XML to be popular really hard.

Khalid