Company Sync

Administrator
Administrator Member, Moderator, Administrator Posts: 2,506
edited 2010-11-05 in Download section
Company Sync
Do you have also a Company called "test" in your Companylist?
So you know how to Update?
Let all user leave Navision, make a Company-Backup, rename the main company to test,restore the Backup... and hope noone logged in in the meanwile.
With this little Tool (only one Form, no side-effect) you can sync any Table you want from one Company to another (e.g. "Main" -> "Test").
Works in any Navision (think so) from 3.70 updwards

http://www.mibuso.com/dlinfo.asp?FileID=1270

Discuss this download here.

Comments

  • rodry
    rodry Member Posts: 7
    =D> Good Tool! (a little dangerous)

    When you select more than one table in Version 5 SP1 there is an error "you must close record ref....")
    In Sync function you need to add the two lines above

    UNTIL RecRefFrom.NEXT = 0;
    COMMIT;
    >>RecRefFrom.CLOSE;
    >>RecRefTo.CLOSE;

    Many thanks
    Marco
  • ara3n
    ara3n Member Posts: 9,258
    this is a nice tool. The only issue is that it's probably too slow for big databases. You could use this tool that generates sql script

    http://mibuso.com/blogs/ara3n/2009/12/0 ... amics-nav/
    Ahmed Rashed Amini
    Independent Consultant/Developer


    blog: https://dynamicsuser.net/nav/b/ara3n
  • rthsw
    rthsw Member Posts: 73
    Tnx to Rodry for the correction, i included the Fix.
    if i release a new version it will include this, so long everyone who want to use this tool just copy the code from Rodry at the same place.

    The Sync is slower than importing a Database, but with the time for exporting, renaming, unloggin all Users and restore it is not so much slower. And it work under the native server too, and you can call it at every time.

    The SQL-Sript will be at least allways the fastest way i think.

Categories