Navision native database and SQL linked server

Vanbever
Vanbever Member Posts: 16
edited 2006-09-02 in NAV/Navision Classic Client
Hi,

We work with a query tool on the Navision native databas with an ODBC-connection. But our query tool gives SQL-statements so it should be better to work on an SQL-database.

I would like to know if there is anyone who have experience with Linked Server in SQL.

Reason: I would like thad the Navision users work on their native database but that the queries are excecuted on the SQL Linked Server.

Koen

Comments

  • dick11
    dick11 Member Posts: 60
    You can just use "normal" SQL in your query. Joins are also possible.
    What is the problem?

    I have no experience with a Linked Server in a SQLServer enviroment. But I think that an extra database would decrease the speed.

    And also: read the documentation and/or query Mibuso for some special "features"
    Dick van der Sar

    www.dasautomatisering.nl

Categories