Our Customer got 44 Companies in Navision, which means on SQL approximately 951 Tables (+SIFT tables etc) * 44 = 41844 Database tables in SQL. 18 Windowslogins and 4 Active Directory Groups. Multiplying 41844 Table with each login * 22 = 920568.
So I think it has to synchronize somewhat 920568 tables/times in total. This is only my own consideration of what’s going on behind all this, since it takes seriously shorter time on Companies only having one Nav Company. Because on this particular customer it takes 3 hours to synchronize, and then I’m running Navision client and synchronizing from the same server as the SQL Server is running on. Is there any best practices for these things, should I setup each company in it’s own SQL database, but then they will lose intercompany functionality and the close open company in one client, and I have to maintain security in each DB.
Please help, any angle to this matter would be appreciated.