Hi all:

I am in the process of migrating the AR Server 3.2.1 database from
SQL 6.5/NT4.0 to Oracle8/Sun Solaris. I configured the AR Server be on an
NT box and remotely connect to the Oracle database on Solaris. I was
successful in completing the migration of the structure, using the Admin.
Tool. However, my problem is data migration, we have 300,000-1,000,000
records in several tables. Remedy Migrator is not an option in our case
since it migrates about 5,000 records a time and it is time consuming. So,
do you know any data migration tool that can best fit for Remedy,
especially, Remedy at the database level has the T and H tables.

Also, how do I maintain the same T and H table nos. with the source
database? Importing the structure using the Admin. Tool, changes the T and
H table nos.on the destination database.

Any suggestion is appreciated how to move the full database from
SQL/6.5/NT4.0 to Oracle8/Sun Solaris?


Zeni Haile
Oracle OCP DBA
Network Access Solutions
(703) 793-4223

_____________________________