Navision Synchronize SQL Query

jubeljoy
jubeljoy Member Posts: 154
edited 2014-07-18 in NAV Three Tier
Dear Masters,
If anybody having Navision Synchronize SQL Query?
Jubelhttp://navisionplanet.com

Comments

  • jubeljoy
    jubeljoy Member Posts: 154
    Anybody having solution for this?? ](*,)
    Jubelhttp://navisionplanet.com
  • tinoruijs
    tinoruijs Member Posts: 1,226
    Perhaps you could explain what you are trying to achieve?
    To me it's not clear, and I'm probably not the only one. ;-)
    Tino Ruijs
    Microsoft Dynamics NAV specialist
  • jubeljoy
    jubeljoy Member Posts: 154
    We are using Microsoft Dynamics NAV 4.0 SP3. While doing any modifications on the Table Structure or introducing new tables. Then User Synchronization is required from Navision. We are having more than 60 users on single server. So when there is any changes occur in the system its difficult do the individual User Synch.
    By analysing this issue I came across an idea that can able synchronize all the given User IDs by Using some SQL Queries. I am asking about this kind of Query. Hope now you can understand.
    Jubelhttp://navisionplanet.com
  • bbrown
    bbrown Member Posts: 3,268
    Switch your database to the Standard Security Model. Life will be much easier.
    There are no bugs - only undocumented features.
  • jubeljoy
    jubeljoy Member Posts: 154
    In our case total servers are around 300+ , so its difficult to migrate entire database to Standard format instead of Enhanced. So let me know SQL option to Synchronise the Navision Users.
    Jubelhttp://navisionplanet.com
  • bbrown
    bbrown Member Posts: 3,268
    jubeljoy wrote:
    In our case total servers are around 300+ , so its difficult to migrate entire database to Standard format instead of Enhanced. So let me know SQL option to Synchronise the Navision Users.

    Not sure what you mean by "..servers are around 300+....". Do you mean you have this problem at 300+ customer sites? Anyways, I still say switch to Standard Security. You'll just need to do it 300+ times. But when it's done, the problem will be over.
    There are no bugs - only undocumented features.
  • jubeljoy
    jubeljoy Member Posts: 154
    Thanks for your reply..

    As per my knowledge for the Standard database also required Synchronization. And that not having any Single user synchronization too.. That's the reason why we are looking for SQL option.
    Jubelhttp://navisionplanet.com
  • bbrown
    bbrown Member Posts: 3,268
    jubeljoy wrote:
    Thanks for your reply..

    As per my knowledge for the Standard database also required Synchronization. And that not having any Single user synchronization too.. That's the reason why we are looking for SQL option.

    The synchronization process under standard security is of much lower impact. Also there are less situations in which it needs to be run. It maintains just a single application role, so yes, there is no single user synchronization. But the advantages far outweigh the loss of that 1 feature. Otherwise, why would Microsoft have put this feature back into the product.

    You will find this topic discussed at length on this forum.
    There are no bugs - only undocumented features.

Categories