• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 252
  • Last Modified:

What is the best way to periodically move IMAGE data from SQL Server to MySQL?

I have a SQL Server 2005 table that contains an IMAGE field. The IMAGE field holds a JPEG string. For simplicity, let's say the table structure is this:
CREATE TABLE photo (
    photoId INT IDENTITY(1,1) NOT NULL,
    photo IMAGE,
    CONSTRAINT PK_photo PRIMARY KEY CLUSTERED (photoId)
)

Open in new window

Every night, I need to copy any newly created records from this table to a similar MySQL table on another server. Here is the intended MySQL table structure:
CREATE TABLE photo (
    photoId INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY,
    photo BLOB
);

Open in new window

Can anyone offer some sage advice on the best way to do this? Thanks!
0
nathan8
Asked:
nathan8
1 Solution
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.
0
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

Featured Post

Cloud Class® Course: Microsoft Office 2010

This course will introduce you to the interfaces and features of Microsoft Office 2010 Word, Excel, PowerPoint, Outlook, and Access. You will learn about the features that are shared between all products in the Office suite, as well as the new features that are product specific.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now