Data Transfer from one database to another

Hi All,

I have got stucked in a situation and need help of you all guyz…

Actually , I am having a database of Axapta and I want to transfer all the data from this database to a Sql Server databse after every fixed period of time.

All this data should get transferred without any manual help,means to say that like after every hour or say two ,the data should get inserted into the new database.

Please help as soon as possible as its very urgent to me …



Although it’s not the only way, I would recommend to look at SQL Server Replication at first.