Microsoft SQL Server has an import and export wizard that assists you in copying Navision data from one database to another. This import and export wizard is available in any version of SQL Server, and it lets you copy tables, data, functions and other database objects.
It’s not something that you do everyday, however, once in a while, you do need to create a new General Posting Setup Line. Usually, I see people going into Financial Management > Setup > Posting Groups > Posting Setup, creating a new entry, defining Gen. Bus. Posting Group and Gen. Prod. Posting Group, and then copying the “Account” values from existing setup (one column at a time).
For one time analysis of data in NAV I always take the quick and easy route of copying data from NAV to Excel using the windows clipboard. Running the relevant table(s) from Object Designer, copy (preferably) all records and paste the whole bulk into an Excel sheet.
Vertalen
