Getting data from NAV to a MSSQL server databae

asembereng

I have a Navision database running on a Native server and an MSSQL server database running a card printing application. I want to transfer some of data from the employee table on the Navision database to the employee table on the card printing database and whenever a new record is added to the Navision database I want the record to be copied to the card printing DB.
How best to achieve this? Thanks

kine

One way is to use ADO within NAV, another is to use SQL Integration Services to copy data from your NAV DB through N/ODBC to SQL.