二進位大型物件 (Blob) 資料 (SQL Server)Binary Large Object (Blob) Data (SQL Server)

適用範圍:Applies to: 是SQL ServerSQL Server (所有支援的版本) yesSQL ServerSQL Server (all supported versions) 適用範圍:Applies to: 是SQL ServerSQL Server (所有支援的版本) yesSQL ServerSQL Server (all supported versions)

SQL ServerSQL Server 提供在資料庫中或遠端存放裝置上儲存檔案和文件的解決方案。provides solutions for storing files and documents in the database or on remote storage devices.

比較 SQL Server 中用於儲存 Blob 的選項Compare Options for Storing Blobs in SQL Server

比較 FILESTREAM、FileTable 和遠端 Blob 存放區的優點。Compare the advantages of FILESTREAM, FileTables, and Remote Blob Store. 請參閱比較用於儲存 Blob 的選項 (SQL Server)See Compare Options for Storing Blobs (SQL Server).

用於儲存 Blob 的選項Options for Storing Blobs

FILESTREAM (SQL Server)FILESTREAM (SQL Server)

FILESTREAM 可讓 SQL ServerSQL Server架構應用程式在檔案系統上儲存非結構化的資料,例如文件和影像。FILESTREAM enables SQL ServerSQL Server-based applications to store unstructured data, such as documents and images, on the file system. 應用程式可以利用檔案系統的豐富資料流 API 和效能,並同時維護非結構化資料與對應結構化資料之間的交易一致性。Applications can leverage the rich streaming APIs and performance of the file system and at the same time maintain transactional consistency between the unstructured data and corresponding structured data.

FileTables (SQL Server)FileTables (SQL Server)

FileTable 功能可將 Windows 檔案命名空間的支援以及與 Windows 應用程式的相容性提供給儲存在 SQL ServerSQL Server中的檔案資料。The FileTable feature brings support for the Windows file namespace and compatibility with Windows applications to the file data stored in SQL ServerSQL Server. FileTable 可讓應用程式整合其儲存和資料管理元件,並且透過非結構化資料和中繼資料提供整合式 SQL ServerSQL Server 服務 (包含全文檢索搜尋和語意搜尋)。FileTable lets an application integrate its storage and data management components, and provides integrated SQL ServerSQL Server services - including full-text search and semantic search - over unstructured data and metadata.

換句話說,您可以將檔案和文件儲存在 SQL ServerSQL Server 的特殊資料表 (稱為 FileTable) 中,而從 Windows 應用程式存取它們,就像它們儲存在檔案系統中一樣,並不需要對用戶端應用程式進行任何變更。In other words, you can store files and documents in special tables in SQL ServerSQL Server called FileTables, but access them from Windows applications as if they were stored in the file system, without making any changes to your client applications.

遠端 Blob 存放區 (RBS) (SQL Server)Remote Blob Store (RBS) (SQL Server)

適用於 SQL ServerSQL Server 的遠端 BLOB 存放區 (RBS) 可讓資料庫管理員在商品儲存解決方案中儲存二進位大型物件 (BLOB),而不是直接儲存在伺服器上。Remote BLOB store (RBS) for SQL ServerSQL Server lets database administrators store binary large objects (BLOBs) in commodity storage solutions instead of directly on the server. 這樣會節省大量的空間,並避免浪費耗費成本的伺服器硬體資源。This saves a significant amount of space and avoids wasting expensive server hardware resources. RBS 會提供一組 API 程式庫來為應用程式定義標準化模型,以存取 BLOB 資料。RBS provides a set of API libraries that define a standardized model for applications to access BLOB data. RBS 也包含維護工具 (例如記憶體回收),以協助管理遠端 BLOB 資料。RBS also includes maintenance tools, such as garbage collection, to help manage remote BLOB data.

RBS 包含在 SQL ServerSQL Server 安裝媒體中,但不會由 SQL ServerSQL Server 安裝程式安裝。RBS is included on the SQL ServerSQL Server installation media, but is not installed by the SQL ServerSQL Server Setup program.