Archives of the TeradataForum

Message Posted: Wed, 20 Aug 2003 @ 15:48:23 GMT

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

I'm trying to move data from a test environment to a production environment. Due to space restrictions I can not do a simple insert/select. What I'd like to do is copy the data to tape, get rid of the test database (thus freeing up that space), and then load the data to production. I know that there are a number of ways to do this, but the one I need more information on is ArcMain. I've never used ArcMain and am unclear about a few things from the documentation.

1) If the table I am copying data to already has data in it, will that data be deleted?

2) Can I copy data from multiple databases (using seperate archive files) and then load those files to my production database? Morevoer, will it work if some of the source databases have slightly different table definitions (i.e. the column order is slightly different)?

Again, I am well aware of other options, so please confine your replies to ArcMain. My knowledge of this utility is sketchy, hence my questions.

Thanks in advance.

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