OT: database advice

[PA]

On Apr 24, 2005, at 23:08, Duncan Lithgow wrote:

> I understand about what sql is and isn't.
>
> Okay, so different db's store data differently, fair enough, how can i
> save a copy of the db contents though, and in what format should I do
> that.
>
> I believe it can be done with a csv list, but that sounds a bit foolish
> to me. There must be a better way.

Perhaps your best bet would be to export your data as a series of 
standard SQL 92 command logs. This would preserve both your data as 
well as their structure and relationships. You could then replay the 
logs against any database to rebuild your data.

Cheers

--
PA, Onnay Equitursay
http://alt.textdrive.com/