Navision with SQL server database

arindam
Member Posts: 176
Hi,
I am new to Navision. I have installed Navision and got the demo company with Navision database. I want to install the demo company on SQL server.
Can anybody guide me how do i do that.
Thanks
Arindam
I am new to Navision. I have installed Navision and got the demo company with Navision database. I want to install the demo company on SQL server.
Can anybody guide me how do i do that.
Thanks
Arindam
0
Answers
-
-Make a backup of the Navision DB (or use an existing fob)
-start finsql.exe and create a new DB.
Navision asks some parameters on how to create SQL-DB.
After creating the DB, restore your backup in the DB.Regards,Alain Krikilion
No PM,please use the forum. || May the <SOLVED>-attribute be in your title!0 -
-
Thank you very much for your early response. It works.
Now I have created all Nav tables in my SQL database. Now my problem is i am not able to get see the menus (Administration, Sales & Marketing, Purchase etc) at the left hand side. From 'Object Designer' I can see all tables but no forms, reports are present.
Moreover when I am openning Navision, it is openning with the existing Nav database. When I trying to change the database it is not allowing me to select SQL Server option. I can see it but it is disabled.
Please advice.
Thanks in advance.0 -
make sure you are using finsql.exe to start navision not fin.exe.0
-
1. Push Alt+F1 to unhide the Navigation Pane.
2. Like Savatage said, make sure you are using finsql.exe to start navision not fin.exe.Confessions of a Dynamics NAV Consultant = my blog
AP Commerce, Inc. = where I work
Getting Started with Dynamics NAV 2013 Application Development = my book
Implementing Microsoft Dynamics NAV - 3rd Edition = my 2nd book0 -
Yes I am using finsql.exe and the navigation pane is unhide.
Still i am not able to see any of the modules. From Object browser I can see all the tables but there are no Forms or Reports present.
Please advice.0 -
Then you didn't restore the entire backup, or the backup file that you used doesn't have the application objects.
Try restoring the same FBK, and see if you can check the application objects only.
If that doesn't work:
- Delete the database
- run the NAV SQL Server client (finsql.exe)
- create a new database (file -> database -> new), accept the defaults for now
- restore the FBK into this new database, and let it finish completely.
Now you should have a NAV database.0 -
Thank you everyone.
It worked. The problem was - After creating a database I created a new company and tried to restore db keeping the new company open. Now I just created a new database and then restore the db. It works.
Once again that you everyone.
Now, I want to see the tables related to the forms. Means if I enter data at customer master form then I need to knwo which physical table it should hit ?
Please advice.
Once again thanks in advance.0 -
Don't know exactly what you want, but may be a few tips:
- If you zoom into the record (CTRL+F8 ), you get an overview of all fields and all values. In the title bar, there is the table caption.
- If you design the form, you can go to the property (on form-level) "SourceTable", where you can see the table.0 -
Thank you once again.
What I exactly want is that, I want to relate a Navision form with SQL Server physical table(s).
If I am entering Customer data from Navison then I need to know which physical table of SQL Server it is going to store. Similarly, when I am entering data in Sales Invoice form, I need to check the data in SQL Server tables. For that I need to know the tables I should look upon.
For that I need to know the physical tables of Navision which are created or imported into SQL Server database.
I hope this time I am able to express my requirement.
Thanks0 -
Wel, in SQL, there are a few types of tables...
1) Company-Independant table: these tables have the same name as in NAV
2) Company-dependant table: these tables have a prefix of the company, followed by the Navision name. E.g.: CRONUS International Ltd.$Customer . "CRONUS International Ltd." is the company name and "Customer" is the tablename
3) SIFT tables: These are not interesting for you, but very interesting for the application. In these tables the sums and such are stored which are used internally by NAV for flowfields
4) System tables: e.g.: Company, User, User Menu Level. These tables are used internally by the application (NAV) ... but in some cases useful to use yourself0 -
That is really very helpful.
Does Navision provide any tool where we can see a form related to which table? As in GP we have Table, Windows and Feild description tool (Tools - Resource Description), where we can get all the information relating to a particular table, form or even a feild. Here we can find out the technical as well as physical name of the object.
Thanks0 -
Thanks sir. U answered all my queries. And it helped me to understand the system and fullfil my requirements.
\:D/=D>
0 -
Of course.
I am also looking for Navision certification.0
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.6K Microsoft Dynamics NAV
- 18.7K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 116 Navision DOS
- 851 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 617 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 320 Dynamics CRM
- 111 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 990 SQL General
- 383 SQL Performance
- 34 SQL Tips & Tricks
- 35 Design Patterns (General & Best Practices)
- 1 Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.6K General
- 1.1K General Chat
- 1.6K Website
- 83 Testing
- 1.2K Download section
- 23 How Tos section
- 252 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions