SQL 2008 FILESTREAM data type

SQL Server 2008 FILESTREAM data type

Directory

Prepare for Work 1

Exercise: Using FILESTREAM data type 2

Preparatory work

Estimated time required to complete this experiment

60 Minutes.

Goal

After completing this experiment, you will be able to:

Handling FILESTREAM data types in SQL Server 2008

Prerequisite

Before completing this experiment, you must have:

Experience in writing Transact-SQL scripts and using SQL Server Management Studio;

C # Grammar knowledge and related experience;

Asp. NET development knowledge and related experience.

Experiment scene

The new FILESTREAM data type in SQL Server 2008 allows large binary data such as files and pictures to be stored directly in the NTFS file system; The document or picture will be maintained as a part of the database, and the consistency of the transaction can be maintained. FileStream allows storage of large binary data, typically managed by the database, and stored outside the database in a separate file, which can be accessed using an API from the NTFS file stream. Using the NTFS file flow APIs makes access to files more efficient and maintains the security and backup characteristics of the database as a whole.

Virtual Machine Environment

Enable the Microsoft Virtual PC from the Start menu or desktop. If Virtual PC Console is not enabled, check the system tray and double-click the Microsoft Virtual pc in the system tray.

Select Sql08 and click Start.

After the virtual machine is running, you can send a Ctrl+alt+del command to the virtual machine by clicking on the right Alt+del.

In the Login window, enter the following information:

User Name:administrator

password:password01!