Hello Everyone,
Does anyone know if there is a Best Practices for upgrading from Jet Reports 2009 to Jet Essentials 2012?
For example, will I have to manually document all of the scheduler tasks and recreate them again?
and are there any recommendations for tuning SQL Server 2008 R2 to work with Jet Essentials 2012?
Thanks for your feedback
Mark
Date
Votes
1 comment
-
Jet Reports Historic Posts Hi Mark,
There aren't a lot of best practices around upgrading. Between Jet 2009 and 2012, things should just work. Scheduled tasks shouldn't have to be recreated or moved unless you're moving to a different computer or reinstalling Windows. The Jet scheduled tasks are created as Windows scheduled tasks so they are specific to Windows and the computer itself.
As far as tuning SQL Server, that is very specific to the reports you are running. There's no overall optimizations you can make for Jet specifically. SQL Server has a profiler which you can run while running a report and it will give you recommendations for indexes you could create that might make the queries run by that report faster.
Regards,
Hughes
Please sign in to leave a comment.