How are objects stored in a sql server database

julien92

Hi guys,

I would like to compare (Object-Properties, Properties, Controls, Code...) and manage some objects from different databases.
I don't want to use the Export (Files->Export) option , I prefer to work directly with the sql server database.

So I would like to know in which tables are stored data that I get using the Export option or what is the way to get the txt file....

Thanks...

kine

No way... :-)

dakyn

Hi all,

8-[ :roll:
Is not there really any way for convert BLOB reference field?
For example to get the code in the objects?

Bye
O:)

bbrown

Use a Stream object to read the data in the image (BLOB). See SQL Books Online for examples.

dakyn

Hi bbrown,

the problem is object format, when I read through the strem object, I don't know whether to interpret bytes.

I think that the field BLOB contains a well precise class built by the Navision and not a simple file text.

What do you think of it?
[-(

jesam

The question is, where does Navision store it's source code. I can't believe that it does a decompile everytime you open op a CodeUnit, so it must store the source somewhere.

dakyn

=;
Are you angry? Have you slept little?
Relaxed!

It was only an example to intend that it is not so easy as to read a text file.

Bye

dakyn

it would be beautiful to know as navision decompiles on-the-fly! :shock:

kine

The data in the BLOB is not "compiled" object (in this case, how will you save object with sysntax error in it?). It is internal format prepared for fast interpreting when needed... It is some binary format how to save the data...

dakyn

OK....

BUT...

All developers with which I have spoken, tell me that I can simply reading data field as binary data.
But what I don't know is HOW to read them. The practical method of how reading binary data and obtain a text variable that had code of object.

For Example:

Table 27 - Item

In Documentation section I have

050506 DCO - Added new field "Test 123"

On a trigger I Have

IF locItem.GET('64756') THEN .....

What I want to get is what I see when I open in design an object in a specific text variable.

Is there someone who has ever done him?
](*,)

kine

dakyn wrote:

What I want to get is what I see when I open in design an object in a specific text variable.

I don't understand this sentence, sorry...

But in general - you are not able to get text representation of the object without using Export function into text file from the menu...

Miklos_Hollender

Please, Dakyn, be reasonable... MSFT put HUGE resources in making compiled objects obfuscated - were they not so, somebody could write a C/SIDE interpreter and then would never pay licence fees again.

dakyn

I believe has to give you some explanations.

I'm navision developer from 1 year and I would like to develop a software similar to the source safe of microsoft for navision.

My idea is improve job of team. Our problem, that is very common, is manage several database. Every database with different objects and different versions.

We are many developer and navision tools are so poor!

I'm developer of visual studio from old vb5 to now (VS 2005). I find strange that It doesn't exist something of the kind yet

For this reason I search a method for read code of object's navision.

I have feeling that I have to wait for Dynamics Navision 5

jesam

We are many developer and navision tools are so poor!

Be carefull, this kind of statement is blasfemy on this forum. How could anybody feel that the standard Navision IDE lacks somehow in functionality ;-) Prepare to get flamed.

I'm developer of visual studio from old vb5 to now (VS 2005).

Oh, that is the reason. You see, we should not expect the same functionality in Navision as in a real development environment, because Navision is not a real development environment, it is merely good for small customizations ;-)

I have feeling that I have to wait for Dynamics Navision 5

I've been waiting since version 3.1 as that is the version we use here.

dakyn

I'm sorry to all !!!

I didn't want to offend the navision world.

SOB! O:)

kine

Easiest way - script some job, which will :

1) Run Navision client for each DB you have
2) Will open object designer and export all objects into text
3) Will separate the file into one object - one file (you can find tool for that on MIBUSO)
4) Will import all these files into Microsoft SourceSafe

Than you can have version control etc. :-)

Rest is just about company processes...

And do not expect some big change in NAV 5... (still, you need understand, that if there will be some easy way how to save the objects in text or something like that, someone can use that to gain access to objects, which are not allowed within his license...)

Dakkon

No buts, the bottom line is that you can't access the raw source code, all you can get is the semi-compiled code. Unless you can get access to the specifications for this format, you can't decompile it any way other than opening object designer or doing a file export. I wish this weren't true, as I would love to be able to implement some nice version control integration. It still boggles my mind that there is no version control integration.