Codeunit, table, report, dataport in sql server

mthe80

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

ara3n

there is a table called object in sql server. it is stored in a blob

DenSter

What do you want to know about that?

mthe80

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

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.

fufikk

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.