reverse engineer MYSql Database into Aware IM mysql database

swiftinitpvtltd

Is it possible to reverse engineer MYSql Database into Aware IM mysql database?
There are 3-system fields are created (REN,RID,RMA) when I created inbuilt mysql based aware IM based app.
How does aware finds that mysql table is BO? For example if I have standard my sql table schema is it possible to convert into Aware IM mysql database with (REN,RID,RMA) ? I know how to connect to external db via aware Im but I think it has some limitations so wanted to check if (REN,RID,RMA) reverse engineer MYSql Database into Aware IM mysql database is possible.

BLOMASKY

Yes, it can be done.

Assuming you have an external database table called Orders with a field called ob_Customers

1st, change the name to ob_Customers_RID (the RID is the foreign key)
2nd, add 2 columns, the REN and RMA. The RMA can remain null, and the REN has to have the text "Customers"

Now, have aware CREATE empty an empty database, shut down aware, restore your good MYSQL table (or whole database) and now Aware will be happy

OK, only sort of happy. Each Aware table has 3 columns, ID (which you probably have), BASVERSION (which can always be set to 1, and BASTIMESTAMP (put in todays date.)

Now Aware is pretty darn happy!

Bruce

tford

Personally I would probably attach to the DB as an external DB, then write process(es) to read each record and create instances in the new native AwareIM database.