Archives of the TeradataForum

Message Posted: Mon, 04 Nov 2013 @ 18:35:12 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

Hi,

The quick answer to your question is "chalk and cheese" (but that may only make sense to people from the UK!).

They are completely different.

An ARCMAIN backup file:

- is not intended to be read by anything other than ARCMAIN

- contains data in 'internal' format, i.e. how it is stored in the database, so a DATE field is in the backup file as a 4 byte integer

- retains compression

- (probably) retains encryption/encoding if you're using tools which do that to your data

- the dat ais transferred a block at a time rather than nominally row at a time

The 'universal format' basically contradicts all of the above.

Does that help?

Cheers,

Dave

Ward Analytics Ltd - Information in motion (www.ward-analytics.com)

	<Prev	Next>		<<First	<Prev	Next>	Last>>