SQL INSERT For Media?

[bobcusick1332964082]

I have a situation where I need to generate SQL INSERT statements from a table with a MEDIA column in it.

For example:

Code: Select all

TABLE: myMedia
COLS:  media_id - TEXT(50 - UUID), media_name - TEXT(255), media_data - MEDIA

I need to generate the statements for each record like:

Code: Select all

INSERT INTO myMedia (media_id, media_name, media_data)
VALUES ('26F07D21-7856-4B09-B69C-554F56819202', 'Test Image', ????)

I'm not sure how to convert the byte array into something that can be inserted into SQL Server...

Any ideas?

Thanks!

Bob

[ROCLASI]

Hi Bob,

Afaik there is no SQL-standard for doing this. You say you need this for SQL Server?
First hit on Google gives me this:
http://social.msdn.microsoft.com/Forums ... getstarted

Hope this gets you further.

[david]

Another idea: export to a backup file a sample record. Check out the resulting sql in a text editor.

[bobcusick1332964082]

Robert - thanks - I know how to do it that way - but I was hoping to avoid having to export all the images, name them, etc. (e.g. was being lazy)...

David - thanks - that was my next move.

I appreciate the feedback!

Bob

[ROCLASI]

Hi Bob,

But why not use Servoy as a data-pump for this?

[david]

If this is a large job, some ideas: http://www.servoymagazine.com/home/2013 ... lugin.html

[bobcusick1332964082]

That's what I'm going to wind up doing - using Servoy itself.

David - I like your multiple headless solution - I've used the same technique before as well - works great!

AGAIN - THANKS GUYS!