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,
Russell
Start Free Trial