Hi,
Our DBA doesn’t want to store image files in our MSSQL 2005 database – he would rather store textfield references to images that are stored on an external server. Is there a way to work like this (elegantly) in Servoy?
Thanks,
Andrew
Yes there is. How are files stored on that server? How do other users have access? What about auditing? Do you need to comply to any regulations? What user can ‘read’ the files from that ‘external server’ and under what condistions? That was just read. Now for writing, and editting, and versioning, what are the possibilities? If stored in DB you can manage it simply from your app logic, if external the same is possible but keep in mind the info you have to manage and audit.
The image files will be stored in a directory on the servoy server.
Right. So which user owns the files? The Servoy user? Or groups? Are they going to map the drive? SMB? or something else? Or would you like Servoy to copy files over? Versioning? Auditing? All can be achieved and having been involved in implementations I can definetely advice but a bit more background would help.
PS. Why does the dba not want the files in the database? It’s much more flexible and secure, and SQL Server 2005 can handle files very well.