Howdy, Stranger!
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.6K Microsoft Dynamics NAV
- 18.7K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 115 Navision DOS
- 854 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 615 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 310 Dynamics CRM
- 109 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 993 SQL General
- 384 SQL Performance
- 34 SQL Tips & Tricks
- 34 Design Patterns (General & Best Practices)
- Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.7K General
- 1.1K General Chat
- 1.6K Website
- 79 Testing
- 1.2K Download section
- 23 How Tos section
- 260 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions
Back to the future - Demodatabase Datetool
Administrator
Member, Moderator, Administrator Posts: 2,500
Back to the future - Demodatabase Datetool
Microsoft has asked me to develop a tool to change all dates in a CRONUS database in one batch. Since a CRONUS database has about 40.000 dates it is handy to have a tool.
The project is called 'Back to the future'.
The tool is based on the SQL conversion tool but handles only and all dates.
Enjoy...
http://www.mibuso.com/dlinfo.asp?FileID=1150
Discuss this download here.
Microsoft has asked me to develop a tool to change all dates in a CRONUS database in one batch. Since a CRONUS database has about 40.000 dates it is handy to have a tool.
The project is called 'Back to the future'.
The tool is based on the SQL conversion tool but handles only and all dates.
Enjoy...
http://www.mibuso.com/dlinfo.asp?FileID=1150
Discuss this download here.
0
Comments
Problem No.1:
This is VERY slow, about 20 minutes to scan Cronus, -1 point. That's after I removed Table 99990 from the list to scan ... with it in I don't think it was going to finish.
Problem No.2:
It's hardwired to 2 Years, no option -0.5 point.
Problem No.3:
It doesn't even try to find the 19428 datetime values., -2 points.
Problem No.4:
It doesn't seem to touch many of the records even though they are found in the scan.
Table 330 "Currency Exchange Rate" is unchanged, as is Table 99000757 "Calendar Entry".
I'm afraid that last one is a killer :bug:, sorry but :thumbsdown: till the next version.
TVision Technology Ltd
REMOVED.
Should been posted here- >>>
viewtopic.php?f=7&t=37650&p=194206#p194206
The tool has been tested with a CRONUS database and that worked.
What is your exact testscenario that fails?