Asked by:
Store Raster files(Images) in SQL SERVER

Question
-
User-2141666569 posted
Dear All,
As I am new to SQL SERVER, i need your help to store my data which in raster format(images) into SQL SERVER 2016.
All suggestions are highly appreciated.
Thanks
Monday, July 23, 2018 9:49 AM
All replies
-
User753101303 posted
Hi,
You should find tons of turorial. The "old" advice was to store a "path" in your db and the file in the file system but you could consider now to use https://www.mssqltips.com/sqlservertip/1489/using-filestream-to-store-blobs-in-the-ntfs-file-system-in-sql-server-2008/ that basically does this for you.
You can also save the db with or without file data and access them through a file share if needed.
Monday, July 23, 2018 9:55 AM -
User-2141666569 posted
Dear PatriceSC,
Thanks for your reply, i have already tried file stream method. But when I am trying to retrieve the raster data from third part software(ERDAS APOLLO) its throwing error as.
"No Geometry found in table".
Please suggest.
Monday, July 23, 2018 10:03 AM -
User753101303 posted
Seems unrelated. This 3rd party system seems to process spatial data and so more likely it expect https://docs.microsoft.com/en-us/sql/relational-databases/spatial/spatial-data-sql-server?view=sql-server-2017 columns into your table.
Monday, July 23, 2018 10:37 AM -
User-2141666569 posted
Thanks Patrice for your valuable time.
Monday, July 23, 2018 11:06 AM -
User347430248 posted
Is your issue solved?
From your last post, It is not clear that whether your issue is solved or not.
If you got the solution then I suggest you to mark the helpful reply as an answer. So that we can close this thread from our side.
If your issue is still persist then try to update the status of this thread.
We will try to provide further suggestions to solve your issue.
Regards
Deepak
Wednesday, July 25, 2018 6:36 AM -
User-2141666569 posted
Dear Deepak,
Thanks for your reply, the issue is still up, As my RASTER DATA ( .tif, .img, .dem) file has spatial references. Can you please suggest me how to store this data in SQL server with spatial references.
(The reason i am asking for spatial references because i want to retrieve this data in third party software ERDAS APOLLO DATA MANAGER, which is throwing error if i am storing data under filestream).
Thanks and Regards
Imtiyaz
Wednesday, July 25, 2018 6:55 AM -
User347430248 posted
I try to find the documentation to save the spatial references with raster data but i did not get any useful article on that.
I suggest you to contact your third party software company to provide any work around for this issue.
Regards
Deepak
Friday, August 3, 2018 6:14 AM -
User-595703101 posted
To manage binary data on SQL Server the easiest way is to keep it in FileTables
FileTables are exposed to use of others just like a Windows File folder so you can simply drag and drop images into those files.
By enabling FileStream feature of SQL Server the FileTable can be reachable in a folder under the default network share for that instance FileStream
Additionally, backup and restore operations of the image files are managed like data of your database seemlessly at the same time. This eliminates the loss of images kept in file folders on the other hand data is in database. Developers can miss the synchronization in previous methods.
But with used of FileStream and FileTables actually the images you see on the FileStream folders are actually kept in special database tables FileTable
Friday, August 3, 2018 7:22 AM