Results 1 to 3 of 3

Thread: BFILE on MS SQL Server

  1. #1
    Join Date
    Nov 2006
    Posts
    3

    Question BFILE on MS SQL Server

    Hello!

    Maybe you know the Type BFILE from Oracle Databases.
    BFILE (External Binary File) is a binary file stored outside of the database in the host operating system file system, but accessible from database tables.

    What is the BFILE equivalent on a Microsoft SQL Server? I could not find one in the MSDN or Documentation - so maybe there is none?

  2. #2
    Join Date
    Nov 2002
    Location
    New Jersey, USA
    Posts
    3,932
    There is nothing like that in SQL Server. You have to store the binary in image data type column, which is BLOB in Oracle.

  3. #3
    Join Date
    Nov 2006
    Posts
    3
    Thank you.
    For those with the same question, there is some Information
    in at Siebel Migration Course - Module 2: Microsoft SQL Server Essentials

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •