SQL Server Programming

Waldo

I know that when you migrated to SQL Server, the users should have less problems with tablelocks. Now, I also know that the developer should develop in another way, when working on a SQL SERVER. Even, when migrated, I suppose the developer should do some changes on the existing code.

Is there a summary of what the developer should change on the existing code, and how the developer should develop on the SQL Server implementation?

Sbhat

Hi Waldo,

If you go to Microsoft partners network, you will find a document that tells you programming changes in SQL environment. Not many changes but some locking functionalities. Please check the partners network for more details.

Thanks
Best regards
Suresh.

nunomaia

In Navision Database there is only table locking, in the SQL SERVER is row locking. Row locking improves performance, to understand I recomend to read the apllication desinger's guide, that explain's very well

I recomend too to use FIND('-') instead of FIND('+') because in SQL server FIND('+') decreases performance, it returns all the records, it's better to use ASCENDING(FALSE) andFIND('-').

Luc_VanDyck

Have a look at the upgrade manual w1w1upgr.pdf which is located on the product CD in the folder Upgtk\Doc. There is a chapter titled "Migrating to the Microsoft SQL Server Option for Navision 3.70" what describes the changes needed.