Nav40 SQL Data Type

twdavis

Recently converted Nav40 to SQL.

Is there a utility available that can be used to look at all tables and fields and recommend the setting of the SQL Data Type in all tables?

Experiencing major speed issues after conversion to SQL. Several "sorting" issues have cropped up in Account Schedule reports, Manufacturing Prod. Order Completions, etc.

All this leads me to believe that I need to visit every table and field and assess the setting of SQL Data Type.

Any suggestions?

Thanks

David_Singleton

Account Schedules and Analysis views are obvious problems, but you wont normally see the issue in too many other places. You know your business, and the reports you run, so just address the fields that you need. There is no need to look at EVERY table.

Waldo

twdavis wrote:

Recently converted Nav40 to SQL.

Is there a utility available that can be used to look at all tables and fields and recommend the setting of the SQL Data Type in all tables?

Experiencing major speed issues after conversion to SQL. Several "sorting" issues have cropped up in Account Schedule reports, Manufacturing Prod. Order Completions, etc.

All this leads me to believe that I need to visit every table and field and assess the setting of SQL Data Type.

Any suggestions?

Thanks

Be aware that when you went to SQL, you have to make sure you "tune" that database. Make sure you let SQL use the right indexes and stuff. As "kriki" would say it: " You will need to finetune the indexes for SQL and this is not something to do for beginners."

kriki

[Topic moved from Navision Attain forum to Navision forum]

Thanx for quoting me Waldo.

Waldo

kriki wrote:

[Topic moved from Navision Attain forum to Navision forum]

Thanx for quoting me Waldo.

No prob.
It's like Teamwork

kriki

[Topic moved from Navision forum to SQL General forum]