Navision with SQL server database

arindam · 2007-04-05

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

kriki · 2007-04-05

-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.

Waldo · 2007-04-05

use the installation guide: w1w1isql.pdf in the Doc folder of the product CD.

Basically, it's just
1) installing the extended stored procedures (xp_ndo.dll)
2) create new database from C/SIDE client
3) resore a .fdb in that database.

arindam · 2007-04-05

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.

Savatage · 2007-04-05

make sure you are using finsql.exe to start navision not fin.exe.

Alex_Chow · 2007-04-05

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.

arindam · 2007-04-05

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.

DenSter · 2007-04-05

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.

Waldo · 2007-04-05

You can also try to:
1) Open Object Designer
2) Click File - Import
3) All Files
4) Select your .fbk file (indeed, your backup file)

If all objects are in your backup file, you can import them this way as well...

arindam · 2007-04-06

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.

Waldo · 2007-04-06

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.

arindam · 2007-04-06

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.
Thanks

Waldo · 2007-04-06

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 yourself

arindam · 2007-04-06

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.

Thanks

Waldo · 2007-04-06

Nope, in NAV we have to use our heads

\:D/

arindam · 2007-04-06

Thanks sir. U answered all my queries. And it helped me to understand the system and fullfil my requirements.
\:D/

=D>

Waldo · 2007-04-06

No problem.
I hope you'll enjoy working with NAV

arindam · 2007-04-06

Of course.
I am also looking for Navision certification.

Howdy, Stranger!

Quick Links

Categories

Navision with SQL server database

Answers