Company Sync

Administrator

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.

rodry

=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

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/

rthsw

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.