d_kamal
asked on
How can i insert an image ( or a big file) into sql server ?
I want to insert an image to test whether backing up the table data using bcp tool will also back up the data ( specially large size) stored in the bolbs is also come to the data file or not
Whether backing up the table data using bcp tool will also back up the data ---
You can use BCP to import / export the image, by creating a format file and selecting the image type.
Have a look here for a demo:
http://support.microsoft.com/default.aspx?scid=kb;en-us;197043
(This highlights a bug on SQL 7 that does not exist on SQL 2000 with one particular insert image type).
This also demonstrates that BCP does export the image files also.
Image perfomance in SQL Server is not as fast as storing the file outside the database.
You can use BCP to import / export the image, by creating a format file and selecting the image type.
Have a look here for a demo:
http://support.microsoft.com/default.aspx?scid=kb;en-us;197043
(This highlights a bug on SQL 7 that does not exist on SQL 2000 with one particular insert image type).
This also demonstrates that BCP does export the image files also.
Image perfomance in SQL Server is not as fast as storing the file outside the database.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Please not that BIG has a maximum limit of 2 GB.
ASKER