insertion of blob

Posted on 2013-06-19
Medium Priority
Last Modified: 2013-06-21
hi guys.

do you know how to get/read blob values from one database and insert it in another database!

I have an application which had a feature not working saying that the blobs are missing.

On inspecting the relevant database table, the blob value are null which should be present in normal circumstances.

how can i read blobs from another normal database and insert it here.

I checked the normal working database and it does not show any binary value but just shows a text "BLOB".

Question by:AmmarDJ
LVL 10

Accepted Solution

John Claes earned 2000 total points
ID: 39259642
Blob values are saved outside the record. this enables the size of the Blob-fields.

are both databases connected?
if so you can use a update select query

if not
can they be connected?
if so please do so and see above

if not.
the I'm afraid you'll have to make a full backup and restore the backuped database upon the target Machine using an other name and then use a update insert query

Author Comment

ID: 39260495
both databases are not connected.

The database with missing blobs is a watcom backup.

what kind of insert statement i would use in the backup with missing blobs because the blobs are binary values.

Should i use the select statement on the normal working database and then insert the blob values retrieved from the select statement on the backup with missing blobs.

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

This article shows gives you an overview on SQL Server 2016 row level security. You will also get to know the usages of row-level-security and how it works
One of the most important things in an application is the query performance. This article intends to give you good tips to improve the performance of your queries.
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…

586 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question