Database Experts! Need your help please ...
Posted on 2002-05-20
I have gotten assigned to creating an data export/import feature into a large database application (sort of a backup or to pass data from one unit to another).
We are using ADO and currently the database is built in Sybase (with plans on using SQL Server/Oracle). Approx. 35+ tables (export and import speed is not an issue).
I have considered using XML because it included the database definition along with the data - but I am not an XML expert plus I am a little leary on added all the necessary references (project size?) - correct me if I am wrong.
But what I would like are some suggestions about exporting and importing data (comma-delimited, something new, XML)? Any type of code or links for me try would be the best option.