Options

Navision with SQL server database

arindamarindam 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

Answers

  • Options
    krikikriki Member, Moderator Posts: 9,090
    -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!


  • Options
    WaldoWaldo Member Posts: 3,412
    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.

    Eric Wauters
    MVP - Microsoft Dynamics NAV
    My blog
  • Options
    arindamarindam Member Posts: 176
    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.
  • Options
    SavatageSavatage Member Posts: 7,142
    make sure you are using finsql.exe to start navision not fin.exe.
  • Options
    Alex_ChowAlex_Chow Member Posts: 5,063
    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.
  • Options
    arindamarindam Member Posts: 176
    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.
  • Options
    DenSterDenSter Member Posts: 8,304
    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.
  • Options
    WaldoWaldo Member Posts: 3,412
    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...

    Eric Wauters
    MVP - Microsoft Dynamics NAV
    My blog
  • Options
    arindamarindam Member Posts: 176
    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.
  • Options
    WaldoWaldo Member Posts: 3,412
    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.

    Eric Wauters
    MVP - Microsoft Dynamics NAV
    My blog
  • Options
    arindamarindam Member Posts: 176
    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
  • Options
    WaldoWaldo Member Posts: 3,412
    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 :wink:

    Eric Wauters
    MVP - Microsoft Dynamics NAV
    My blog
  • Options
    arindamarindam Member Posts: 176
    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
  • Options
    WaldoWaldo Member Posts: 3,412
    Nope, in NAV we have to use our heads :wink:
    \:D/

    Eric Wauters
    MVP - Microsoft Dynamics NAV
    My blog
  • Options
    arindamarindam Member Posts: 176
    Thanks sir. U answered all my queries. And it helped me to understand the system and fullfil my requirements.
    \:D/ :D =D>
  • Options
    WaldoWaldo Member Posts: 3,412
    No problem.
    I hope you'll enjoy working with NAV :wink:

    Eric Wauters
    MVP - Microsoft Dynamics NAV
    My blog
  • Options
    arindamarindam Member Posts: 176
    Of course.
    I am also looking for Navision certification.
    :)
Sign In or Register to comment.