LearnItFirst User Forum

Welcome Guest

Search | New Posts | Members | Log In | Register

SQL Server Forum - LearnItFirst.com » SQL Server Database Administration » General SQL Database Question & Answer » Regarding replication of image type data between two database servers

Regarding replication of image type data between two database servers

Options

Previous Topic · Next Topic

Mdec

Posted: Tuesday, December 01, 2009 9:49:53 PM

Rank: Newbie

Joined: 12/1/2009
Posts: 1
Points: 3
Where do you live?: Australia

Hi,

I need some advice regarding replication of database tables which includes binary data stored as Images.

Currently the database in the server stores PDF files as binary Images in the tables. A web service is used to get data from the .NET application and to store it in the database. There is a new requirement to replicate all this data to another database in a server located at a different site.

Can someone please advise me on the following?
1. Do you think storing PDF files as binary images is the best approach or would it be good to store in a file server? Most PDF file sizes are less than 1MB, but there can be thousands of these created. Currently this is implemented as storing the PDF files as binary images in the database. But, I would like to know which would be the best solution.

2. How will the performance be if, Two-Way replication is used for databases located in different sites and which includes image data?

3. According to my understanding Two-Way replication can only be implemented using SQL Server 2005 and SQL Server 2008. Is that correct or can it be implemented using older versions as well?

4. Is there any other way than, using Two-Way replication to replicate data (which includes image types) to a database server located at a different site? Please note that image data on one server needs to be deleted after a certain action is made and it will remain on the other to gather the history.

5. What sort of an internet connection is required to perform replication between two sites?

I would greatly appreciate if someone could advice me on the above.

Thanks!

Scott Whigham

Posted: Friday, February 26, 2010 9:05:21 AM

Rank: Super Mod

Joined: 3/20/2006
Posts: 476
Points: 1,053
Where do you live?: Dallas, TX

Hi there - sorry for the tardy reply. I suspect that I am too late to help Frown

I'm assuming this is for SQL 2008:

1) Have you looked at filestream? http://msdn.microsoft.com/en-us/library/bb933993.aspx

2) Filestream is supported with replication: http://msdn.microsoft.com/en-us/library/bb895334.aspx#Replication

3) Sure - depends on the type of replication as to what the support is

4) Yes, there are lots of 3rd party tools to do this as well as hand-written scripts (PowerShell for example)

Users browsing this topic

Guest

Forum Jump

You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.