Host Migration

kklosson

I need to migrate my app from one host to another which I've never done before and I want to validate my plan. My main concern is the data and not screwing up the licencing. Here's the basic steps wrt the data and BSV:

Install MySql on new host
Install AwareIM trial on new host
Create business space with same name as current system
Export all application tables from old host (just tables that start with BSV name)
Export BSV from old host
Import BSV to new host
Import data from step 3
Work w/ Support for license transfer

My questions:

a. Should I install the trial or download the setup from my AwareIM account? Will that even work?

b. Does my BSV have to be imported from the exact same AwareIM version as the target version?

c. If anyone has this documented already, please post here or PM me.

Powerm

Install MySql on new host ---> Yes
Install AwareIM trial on new host ---> Yes
Create business space with same name as current system ---> Yes
Export all application tables from old host (just tables that start with BSV name) ---> Yes
Export BSV from old host ---> Yes
Import BSV to new host ---> Yes
Import data from step 3 ---> Yes
Work w/ Support for license transfer ---> Yes

My questions:

a. Should I install the trial or download the setup from my AwareIM account? Will that even work? ---> Install trial and see with Support

b. Does my BSV have to be imported from the exact same AwareIM version as the target version? ---> Yes, same version or higher build

kklosson

Thanks for the confirmation.

On a., Not quite clear. You say install the trial then just work with support for license transfer?

On b., You say I can export from build 1611 and import to build 1612 (or whatever is current?)

tford

A - yes, just contact support@awareim.com on the license question

B- yes

kklosson

Just an update that after moving my application and database exactly as described above, I started getting duplicate key errors in some tables. I hired a DBA to check into it and this is the summary of her response... note that the BSV is called pobits...

Summary: I believe I have fixed the problem. The sequence number for the IDs in the pobits* tables was not correct after the data import. I corrected the sequence number (MAX_ID in bas_idgen) to be past the maximum ID I found in the pobits* tables. In the future, you would have to ensure the value you have for bas_idgen is imported into the new database.

So according to her, in addition to moving the BSV tables, one should also export/import the bas_idgen table. If anyone can confirm that, please do.

Lastly, we could sure use a definitive reference on how to migrate a database from server to server. Since AwareIM completely abstracts the database from the user, we users don't have a perfect understanding of the bas_ tables. I for one, would volunteer to craft a one-pager on this topic if Support would agree to validate it and include it in the user docs.

hpl123

kklosson wrote
Lastly, we could sure use a definitive reference on how to migrate a database from server to server. Since AwareIM completely abstracts the database from the user, we users don't have a perfect understanding of the bas_ tables. I for one, would volunteer to craft a one-pager on this topic if Support would agree to validate it and include it in the user docs.

Good idea.

RocketRod

This may not have been you requirement but.....

Another one of the many reasons why I would prefer to be able to have each BS in its own DB. If you wanted to transfer a DB to another host you would just be able to transfer the whole DB. Whereas to separate out the tables required and leave the existing BS's and their tables on an existing host is so much more difficult.

There are so many good reasons for being able to separate out a BS into it's own DB.

Cheers Rod

weblike

Hi,

I have followed the steps above and I'm having trouble with 1 app from 5.

I have exported the bsv from old server
Created same bsv to new server
Imported the bsv from step 1
When I'm trying to publish I get thi error:

Duplicate column name IncomingEmailTLS

Any advice would be much appreciated.