fredscifi - Friday, March 16, 2012 3:25 PM:
I'm totally new to ARAS, and have been tasked with migrating data from an old 8.1 JANUS database into a new 9.3 database.
I used RedGate SQL Data Compare to synchronize data between the databases, copying the 8.1 data to the new 9.3 database. This took a while, as I had to account for all the various foreign key associations and include more tables than I thought I would.
The RedGate SQL Data Compare successfully synchronzed the two databases, but I obviously did something incorrectly. Going into the Innovator using the JANUS database, I'm now getting the message "Invalid column name History_ID". I know that there is no History_ID in any of the 9.3 tables. Using RedGate, I mapped the 8.1 History_ID column to the 9.3 Team_ID column. It was the only thing that seemed to match.
Does anyone know where in the JANUS database that "History_ID" value is stored? And am I wasting my time trying to move the data using this method?
