Codeunit, table, report, dataport in sql server

mthe80
mthe80 Member Posts: 27
edited 2006-01-03 in NAV/Navision Classic Client
Dear Mibusoer,

Last night when I browse to this forum, I found a psoting about where Navision placed the object (codunit, table and etc) in sql server.

I am trying to relook again, but cann't find it again :( .

Can anyone help me about this?
TIA

Comments

  • ara3n
    ara3n Member Posts: 9,258
    there is a table called object in sql server. it is stored in a blob
    Ahmed Rashed Amini
    Independent Consultant/Developer


    blog: https://dynamicsuser.net/nav/b/ara3n
  • DenSter
    DenSter Member Posts: 8,307
    What do you want to know about that?
    Daniel Rimmelzwaan
    RIS Plus, LLC
  • mthe80
    mthe80 Member Posts: 27
    I am just currios with the empty database when creating from scartch.

    Can we just transfer the object table into another database without restoring the demo database?
  • ara3n
    ara3n Member Posts: 9,258
    There is more than just the object that needs to be transfered to create a new db. If you want to create a blank database. Create from navision a new database. Export all objects from your current tabase and import them into the new database.
    Ahmed Rashed Amini
    Independent Consultant/Developer


    blog: https://dynamicsuser.net/nav/b/ara3n
  • fufikk
    fufikk Member Posts: 104
    If you're planning to create dbs often you could use the model database of sql server. The idea is, that every time sql creates a new db, it copies the content of the model database.

    So copy the database objects from your database to model database and every time you create a new db all of your objects will be there.

Categories