navison table export to ms sqlserver 2000

Hi! We have navision 2.50 on a windows nt 4.0 server running. I want every week automatically export the ten most important navision tables to a microsoft sqlserver 2000. How can I do that? Thanks´!

try this: 1.Create navision database on mssql7.0. or mssql2000 with compatibility level 7.0 2. create dataport for export ‘top10’ tables from old navision database and run it. 3… and then for import to new navision sql database 4. now you have tables in sql database. Use transact sql or external application to work with data. it s possible. But is it the right way?

Use ADO (Connection,Command). Generate “INSERT INTO” sql script and after this run it using ADODB.Command (connect ADO.Connection to SQLServer) Only one problem - manual run. In this case you do not depend on Navision’s database type (SQL or Native). Or you can write small external application which uses ODBC connections for SQLServer and Navision (also generating SQLs). This application you can schedule on server. Business Applications Programmer Sertified Navision Developer SIA “Sintegra” Latvia