Notifications
Announcements
No record found.
Is there a way to query the contents of tables within 2.6 Navision? I would like to make sure all the data is being carried over during the Upgrade to NAV2013R2
*This post is locked for comments
Hi Kim,
depends a little. Let's say you can, with some effort, sure.
What to do:
1. You should open (a copy of) the database with a current NAV2009R2 native client.
2. Compile all objects.
3. Import FieldCheck (TM), www.mibuso.com/dlinfo.asp
4. Do the steps required for SQL Server preparation.
5. Make a complete .fbk backup.
6. Create a NAV2009R2 SQL database of sufficient size with the finsql client.
7. Import the .fbk (can take a while, I would suggest running the finsql client directly on the server - no installation required, just copy the client directory to it),
8. Access this database via T-SQL or your tool of choice for comparison.
If the 2.6 database already runs on SQL, though, well... skip to 8. :)
with best regards
Jens
Is there any other way to view the contents of the table like within Nav 2.6, but not with the table entry screen, that will show all fields and contents?
Development Environment, select table, run? Is that what you mean by table entry screen? Aside from this, only the access via SQL, or ODBC for a native database, if you have installed it (and it actually works, albeit slow).
What do you want to run as verification? A complete table export? You can do this with dataports, or with code writing a text or binary file. But from what I know, the SQL access is the best option. Especially when you have many large tables and want to make plausibility checks.
Thank you very much, I have really just been developing in NAV2013R2 so my knowledge of 2.6 is very light.
Connecting via ODBC you can query all the Nav 2.6 tables with MS Access or Excel. If you are comfortable with MS Access and the 2.6 DB isn't enormous this works well.
Thank you
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
