Advertisement

01.21.2008 at 03:38PM PST, ID: 23099748
[x]
Attachment Details

Use TSQL to import binary (img) data from file location

Asked by grendel777 in SQL Server 2005, Databases Miscellaneous

Tags: Microsoft, SQL Server, 2005, TSQL, 2005

Hello Experts, I have two SQL Server 2005 databases on the same server.  The old one, call it DB1, has a table which contains a string value varchar(100)) for the name of an image (jpg) which is at a known location on the server.  The new one, call it DB2, needs to store that image as binary data rather than just a pointer.

Is there a way to import the binary data via tsql, or do I need an external tool like .Net?  A coworker has created an external tool, so I only need to know if it's possible.  I'm creating a sproc to bring over the other data, and I'd like to roll in the images if possible.

Thanks,
RussellStart Free Trial
[+][-]01.21.2008 at 04:34PM PST, ID: 20710938

View this solution now by starting your 7-day free trial. Setting up your free trial is quick, easy, and secure. We will return you to this solution, unlocked, when you're done.

 

About this solution

Zones: SQL Server 2005, Databases Miscellaneous
Tags: Microsoft, SQL Server, 2005, TSQL, 2005
Sign Up Now!
Solution Provided By: dportas
Participating Experts: 1
Solution Grade: A
 
 
[+][-]01.22.2008 at 01:58PM PST, ID: 20718847

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
 
Loading Advertisement...
20080716-EE-VQP-32 / EE_QW_2_20070628