Navision Team Development on SQL Server

ara3n

One of the issues with working on server in Navision with other developers is that objects get overwritten. I've written a tool that prevents this from happening. This works on SQL 2005 only. It is written in .NET sql CLR.

I've blogged out it in here
http://mibuso.com/blogs/ara3n/2008/05/1 ... elopement/

Download the zip file. Import the fob (one table). Run the sql script, and you are ready to do team development on sql server.

Comments are welcome.
This tool was written on my free time.

Enjoy.

kine

It seems that many of us are using same "tools" to do such an "access controlling".

NavStudent

OMG this automated checkout/checking object for Navision.

well the check back in is manual.

This is great. No more lost objects or merging of objects. !!!!!!!!!!!!!!!!!

thank you.

kine

The checkout can be "semi-automatic". Just develop tool which will export the objects into text, on request and remove the locks. Than you can have another system which will take the exported objects and save them into some repository with additional informations which you can enter during the export (e.g. on some form). We have such a "Version Control" which keep our history of object changes with documentation and change descriptions and modification tracking etc... ;-)

bostjanl

kine wrote:

.. Just develop tool which will export the objects into text, on request ...

"Just"? :-k

Isn't this THE problem regarding team development in NAV? If we could automatically export object to text, that we could use almost any versionig system (VSS,..).

BostjanL

jlandeen

Yeah if only we had a way of automatically exporting objects as text instead of just binary it would be easy to integrate with something like Visual Source Safe...maybe in NAV 2009?

garak

Why not use the triggers in table Object on SQL :?:
So, ever when a user change a object the sql trigger will be fired ...
In these triggers you can fill out a new table like "Object Versions" (include the BLOB Reference).

So, you can everytime restore your old versions.

ara3n

Yes, Garak
There is already a mod available in the download section.

garak

realy ? ](*,) and i develop my own solution ](*,) ](*,) ](*,)

jlandeen

Yeah...I hear ya...I think a lot of us have built/hacked/fudged together something that kinda does the same thing

This is one of the simplest tools that i've seen yet so I quite like it.