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.



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

_____________________________

Not sure about the first bit. Perhaps extract the tables from SQL into flat
files, table by table, then import into Oracle using SQLLDR....?

Second bit - to preserve table ids. There is a CONTROL table that holds the
next id for tables. When a table is imported the enxt number is taken.

To preserve them all you would have to import them one at a time ensuring
thye took the right number. You can update CONTROL to get the number you
want, but you'll have to import one for at a time.



Neil Anderson
Senior Systems Developer
Halifax plc (UK)

disturbed_work@yahoo.co.uk
disturbed_uk@yahoo.com

Mobile: 07785 372821

'This message is attributable to the sender and does not necessarily reflect
the view of Halifax Group plc or its subsidiaries'
----- Original Message -----
From: "Haile, Zeni"
To:
Sent: Wednesday, October 03, 2001 7:00 PM
Subject: Data Migration


> **
>
> 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.
>
>
>
> Zeni Haile
> Oracle DBA
> Network Access Solutions
> (703) 793-4223
>
>
________________
_____________
>

> You may also control your subscription options, including UNSUBSCRIBE, at
www.ARSLIST.org

_____________________________