Databases
StackOverflow2013
Postsdbo
POExport large amounts of binary data from one SQL database and import it into another database of the same schema
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POExport large amounts of binary data from one SQL database and import it into another database of the same schema
    primarykey
    data
    text
    <p>I have one database with an image table that contains just over 37,000 records. Each record contains an image in the form of binary data. I need to get all of those 37,000 records into another database containing the same table and schema that has about 12,500 records. I need to insert these images into the database with an IF NOT EXISTS approach to make sure that there are no duplicates when I am done.</p> <p>I tried exporting the data into excel and format it into a script. (I have doe this before with other tables.) The thing is, excel does not support binary data.</p> <p>I also tried the "generate scripts" wizard in SSMS which did not work because the .sql file was well over 18GB and my PC could not handle it.</p> <p>Is there some other SQL tool to be able to do this? I have Googled for hours but to no avail. Thanks for your help!</p>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. USa_horse_with_no_name
    1. USKlay
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    2. PO
      singulars
      1. PTAnswer
    3. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POExport large amounts of binary data from one SQL database and import it into another database of the same schema
      1. This table or related slice is empty.
      1. VTUpMod
    1. COWhich DBMS are you using? Oracle? Postgres?
      singulars
      1. POExport large amounts of binary data from one SQL database and import it into another database of the same schema
      1. USa_horse_with_no_name
    2. COHe mentioned he used generate scripts wizard in SSMS, so I imagine its Sql Server Management Studio
      singulars
      1. POExport large amounts of binary data from one SQL database and import it into another database of the same schema
      1. USBen Anderson
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload