AssetCenter 4.1 and above Migration

[rquindip]

Has anyone successfully migrated from 3.x to 4.x?

 

[wrueckert]

I did, from 3.6 to 4 .1.1 with the migration - script
In general it was succesfull.

Some points need attention.
f.i.: my customer used "/" as a character in the model names like "-" is used (stupid...).
That doesent' work with the migration routine. Correct it in 3.6.

And:
Don't rename the Name and the Login of the Admin! must be "Admin" !!!! in AC3.6.

Wolfgang

 

[pearljam]

For the '/' in the source database, this is only for Sybase and SqlAnywhere RDBMS. In this case, you have to check there is no '/' in the fields that are mapped to a fullname. Here is the list of fields concerned:
amSoftware: Publisher, Name, VersionLevel
amProduct: Brand, Model
amContract: Ref
amPOrdLine: ItemNo
amAdjustment:ItemNo
amItemListVal (where Identifier='amBrand'): Value
amFamily: Name, Brand
amAsset (Category.bHardware=1): ComputerName, AssetTag
amInvoice: InvoiceNumber
amCompany: Code

pearljam

 

[wrueckert]

Hi, pearljam,

I regretfully need to say: the source as the target DB was Oracle 8.x

Wolfgang

 

[pearljam]

Hi,

Check the migration.xml file you have with peregrine support. They update it often and your pb have been fixe for oracle, mssql and db2. Maybe your file is not up to date.

pearljam

 

[rquindip]

pearljam,

Thanks for the tip!

rquindip