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 IDENTITY(1,1) NOT NULL, photo IMAGE, CONSTRAINT PK_photo PRIMARY KEY CLUSTERED (photoId) )
Can anyone offer some sage advice on the best way to do this? Thanks!
CREATE TABLE photo ( photoId INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY, photo BLOB );
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
10 Experts available now in Live!