Welcome, Guest
Username: Password: Remember me

TOPIC: How to migrate from 8.3.11 32 bit to 9.2.0.3 64bit and use Oracle Repository

How to migrate from 8.3.11 32 bit to 9.2.0.3 64bit and use Oracle Repository 1 year 7 months ago #17752

New server is 64bit, 32 bit oracle install does not run, so have VI 9.2.0.3 64bit installed.
How best to migrate older VI 8.3.11 32bit using .mdb/Oracle repository.

have tried conversion 6 different ways and each has run into some 64 vs 32 bit issue, or column difference in Oracle between 9.2 and 8.3 versions.

Please Log in or Create an account to join the conversation.

How to migrate from 8.3.11 32 bit to 9.2.0.3 64bit and use Oracle Repository 1 year 7 months ago #17753

  • admin
  • admin's Avatar
  • Away
  • Moderator
  • Moderator
  • Deeds not Words
  • Posts: 7665
  • Karma: 33
  • Thank you received: 434
Hello.

The process follows

Make repository backup using version VI 8.3.11 32bit.
Backup Zip file must have one file inside.

Create a brand new repository using VI 9.2.0.3 64 bit
Perfom the backup restore.

Run the following SQL against repositiry.

INSERT INTO OBJECTS_TREE
(OBJECT_ID,
PARENT_ID,
NAME,
OBJECT_TYPE
)
Select
OBJECT_ID*-4 as OBJECT_ID,
PARENT_ID,
'MongoDB' as NAME,
903 as OBJECT_TYPE
From
OBJECTS_TREE
where OBJECTS_TREE.OBJECT_TYPE=320

UPDATE OBJECT_TYPES
set OBJECT_TYPE_GROUP=22000
WHERE OBJECT_TYPE= '903'

It will enable support for MongoDB

Please keep us posted on your progress
Mike

Please Log in or Create an account to join the conversation.

How to migrate from 8.3.11 32 bit to 9.2.0.3 64bit and use Oracle Repository 1 year 7 months ago #17754

Upon creation of new Oracle repository for 9.2, I click RESTORE and get 2 attached messages.
Not finding way to path to 8.3 MDB to restore.
Attachments:

Please Log in or Create an account to join the conversation.

How to migrate from 8.3.11 32 bit to 9.2.0.3 64bit and use Oracle Repository 1 year 7 months ago #17755

  • admin
  • admin's Avatar
  • Away
  • Moderator
  • Moderator
  • Deeds not Words
  • Posts: 7665
  • Karma: 33
  • Thank you received: 434
Check do not execute any actions
Mike

Please Log in or Create an account to join the conversation.

How to migrate from 8.3.11 32 bit to 9.2.0.3 64bit and use Oracle Repository 1 year 7 months ago #17756

Connected to 9.3 Ora repository
clicked restore|"Do Not Exec"
restore a 8.3 .mdb, restore runs
nothing of restored .mdb structure showing up
Attachments:

Please Log in or Create an account to join the conversation.

How to migrate from 8.3.11 32 bit to 9.2.0.3 64bit and use Oracle Repository 1 year 7 months ago #17757

  • admin
  • admin's Avatar
  • Away
  • Moderator
  • Moderator
  • Deeds not Words
  • Posts: 7665
  • Karma: 33
  • Thank you received: 434
It usually shows error in the bottom left corner.

Can you email us your repository backup please, so we can test it here
Mike

Please Log in or Create an account to join the conversation.

We have 138 guests and 5 members online