Navision Team Development on SQL Server

ara3n
ara3n Member Posts: 9,258
edited 2008-08-14 in NAV Tips & Tricks
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.
Ahmed Rashed Amini
Independent Consultant/Developer


blog: https://dynamicsuser.net/nav/b/ara3n

Comments

  • kine
    kine Member Posts: 12,562
    It seems that many of us are using same "tools" to do such an "access controlling".
    Kamil Sacek
    MVP - Dynamics NAV
    My BLOG
    NAVERTICA a.s.
  • NavStudent
    NavStudent Member Posts: 399
    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.
    my 2 cents
  • kine
    kine Member Posts: 12,562
    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... ;-)
    Kamil Sacek
    MVP - Dynamics NAV
    My BLOG
    NAVERTICA a.s.
  • bostjanl
    bostjanl Member Posts: 107
    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
    jlandeen Member Posts: 524
    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?
    Jeff Landeen - Sr. Consultant
    Epimatic Corp.
    http://www.epimatic.com
  • garak
    garak Member Posts: 3,263
    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.
    Do you make it right, it works too!
  • ara3n
    ara3n Member Posts: 9,258
    Yes, Garak
    There is already a mod available in the download section.
    Ahmed Rashed Amini
    Independent Consultant/Developer


    blog: https://dynamicsuser.net/nav/b/ara3n
  • garak
    garak Member Posts: 3,263
    realy ? ](*,) and i develop my own solution ](*,) ](*,) ](*,)
    Do you make it right, it works too!
  • jlandeen
    jlandeen Member Posts: 524
    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.
    Jeff Landeen - Sr. Consultant
    Epimatic Corp.
    http://www.epimatic.com

Categories