Bring data to Axapta Table.

I am using Axapta 2009.

I have a third party software they are using the same sql server but different database.

When the data is inserted in this table i want to bring in to AX database. But the problem is when i transfer the data using the database level i am getting the problem in generating the recid and data area id.

Please if some one have done any thing like this. Guide me please.

Thanks.

Hi Kami,

Generating recId is bit complicated at SQL level.

This may help you - http://objectmix.com/axapta/788318-systemsequences-table.html