Solved

Replication with data type "Image".

Posted on 2001-07-30
4
224 Views
Last Modified: 2012-06-27
Hi,

  When replicating data from the Publisher/Distributor to the subscriber, I was wondering what happens if there is image datatypes within a row thats being replicated?

  I know that the image path is stored in the row(but this is transparent?),not the actual image file,but what happens if someone modifies the image data on the publishing Server(changes/deletes/updates the image) - does this pull across the new image within the row when replicated?

Thanks!
0
Comment
Question by:IanJudge
  • 2
  • 2
4 Comments
 
LVL 142

Expert Comment

by:Guy Hengel [angelIII / a3]
ID: 6336727
If a row contains only the path to the image file, then the image file itself is NOT replicated by the SQL replication!!!!
What you need is a separated file replication implementation... Either you can implement it using OS built-in replication (Win2k), or need 3rd party tools.

Cheers
0
 

Author Comment

by:IanJudge
ID: 6337274
Thanks,
What happens if the row contains image Datatypes,are they pulled across each time you replicate?
 
If you replicate a whole table containing image datatypes and text datatypes,will it pull ALL the images across,regardsless if there has been an update to the image?
0
 
LVL 142

Accepted Solution

by:
Guy Hengel [angelIII / a3] earned 200 total points
ID: 6340357
This depends on the replication method.
If you use a snapshot replication, all data (including the images) will be replicated at every replication.
using a transactional-based replication will replicate only modified data, but you will need to update some other colums that the image/text datatype because those modifications are not included in the transaction log.

Cheers
0
 

Author Comment

by:IanJudge
ID: 6340514
ok,thats all I needed to know,thanks! :o)
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
I have a large data set and a SSIS package. How can I load this file in multi threading?
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.
Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties

861 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

Need Help in Real-Time?

Connect with top rated Experts

24 Experts available now in Live!

Get 1:1 Help Now