Navision Synchronize SQL Query

jubeljoy

Dear Masters,
If anybody having Navision Synchronize SQL Query?

jubeljoy

Anybody having solution for this?? ](*,)

tinoruijs

Perhaps you could explain what you are trying to achieve?
To me it's not clear, and I'm probably not the only one. ;-)

jubeljoy

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.

bbrown

Switch your database to the Standard Security Model. Life will be much easier.

jubeljoy

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.

bbrown

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.

jubeljoy

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.

bbrown

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.