Archives of the TeradataForum

Message Posted: Thu, 03 Oct 2002 @ 14:08:30 GMT

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

Hi All,

I need to archive & Restore a database from one RDBMS environment to a other.

Following script works within the same environment, but fails under different environment.

------------------------------------

logon tcrm/user1,pal;

ARCHIVE DATA TABLES (iastest2),
RELEASE LOCK,
INDEXES,
FILE=textias;
LOGOFF;

------------------------------------

logon tcrm/user1,pal;
RESTORE DATA TABLES (iastest2),
RELEASE LOCK,
FILE=textias;
LOGOFF;

Please advise, how this can be done and any samples would be much appreciated.

Cheers

Ganesh

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