ultegra
18th March 2009, 05:09
Good day to all gurus,


I am doing a data syncronization between Oracle 10g on AIX (production server) and MS SQL 2005 on MS Windows 2003 server (backup server). I successfully convert all oracle data types to MS SQL format and also manage to dump all the data into MS SQL except company 000 tables or better known as tools tables. As being told my my Baan consultant, 000 tables are not meant to replace.


Now problems arise,

First when I log into session, I got Parameters error, so I went to initialise parameters. The error gone, but I got a new one which is number group error, and all options in the session are deemed.

This error only appear on all transactional session. In static session e.g. common tables, I can add, edit and delete item.


What I want know is that is there any work around to make my LN on windows server work by using direct DB syncronzation? Using sequential dump is too slow.

If 2 different LN DB can be sync with each other by passing LN application. It is a major break through for data mirroring.

Thanks!!!

dave_23
20th March 2009, 01:29
Are both of your Baan instances on windows and in the same directory format?

If so then you can bring over the 000 companies and be fine (there are a few things you need to change, but not a huge deal.)

Dave