Howdy, Stranger!
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.5K Microsoft Dynamics NAV
- 18.5K 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
- 262 Dynamics CRM
- 109 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 992 SQL General
- 385 SQL Performance
- 33 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
- 259 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions
Options
External attachment database
Yury
Member Posts: 59
Hello everybody!
You know, that NAV has Record Links, Incoming Documents, BLOB fields to store any binary files (Excel, Word, CSV, etc.) or links to URL or common network files. It's great and widely used.
Our purpose was to store all external attachments in db, but not in production, in additional, only for files. In production db we have only links from any record to external db, where binary data is stored. I've done it with additional SQL database and some functions from NAV.
Is the anybody have experience with the similar task? May be there exist some interesting in-box solutions, which I missed.
Thanks in advance!
You know, that NAV has Record Links, Incoming Documents, BLOB fields to store any binary files (Excel, Word, CSV, etc.) or links to URL or common network files. It's great and widely used.
Our purpose was to store all external attachments in db, but not in production, in additional, only for files. In production db we have only links from any record to external db, where binary data is stored. I've done it with additional SQL database and some functions from NAV.
Is the anybody have experience with the similar task? May be there exist some interesting in-box solutions, which I missed.
Thanks in advance!
Regards,
Yury
Yury
0
Answers
Thanks for the idea, Juhl, but I forgot to mention, that it should not be cloud solution.
Yury