Posted by: 2stepsback | October 14, 2005

XML Ideas: Backup and restore between databases

Since XML is free-form and universal by definition, if all major database vendors would support a new xml-dump protocol, it would be very easy to take data dumps from one database (I am talking of the data only – everything that we write sql for, and of course, a lot of standardization should also go into it) and load the dump into another. Of course, SQL scripts are obviously there
but XML, with a little work can also do the same job. It will require database vendors to read from this standardized XML format and write to this new standardized XML format. The added plus is that XML databases and data applications can also benefit from this kind of a dump format.



%d bloggers like this: