?
Solved

Replication with data type "Image".

Posted on 2001-07-30
4
Medium Priority
?
275 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 143

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 143

Accepted Solution

by:
Guy Hengel [angelIII / a3] earned 600 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

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Microsoft Access has a limit of 255 columns in a single table; SQL Server allows tables with over 255 columns, but reading that data is not necessarily simple.  The final solution for this task involved creating a custom text parser and then reading…
This shares a stored procedure to retrieve permissions for a given user on the current database or across all databases on a server.
Viewers will learn how the fundamental information of how to create a table.
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…
Suggested Courses

621 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