tags:

views:

25

answers:

1
Q: 

Local stored pictures as hyperlink and replication

Dear All, I have a problem. I havea db on the SQL 2005 and will have it replicated to 2-3 other servers but if I have stored hyperlinks that are linked to the pictures on that main server how can I make also the replication with the same setup.

Is there any way that when I move folder with the pictures to the replicated machine somehow edit automatically the links? It does not make sense but I have to ask? Or is there any other scenarios that I can use?

+1  A: 

If you were using SQL Server 2008 then you could leverage the new FileStream feature that allows you to store binary large object (BLOB) data as files on the file system without breaking the bond with the row. Moreover, FileStream is also supported by backup and replication processes. Here is an article about FileStream feature.

With SQL Server 2005, you have to do it manually.

orka  2010-10-18 19:01:46
Thanks Orka, I am using SQL 2005 so that means I have to find another way because I have around 3 000 pictures.....
Tony  2010-10-18 19:31:44
In that case, i would recommend you to store hyperlink/url of your pictures as a relative path that is start with a parameterized prefix (server/domain name + rootpath etc). This way you can use any file sync software to replicate files between servers and every server can have its own prefix to append to the hyperlinks. I hope this makes sense.
orka  2010-10-19 10:09:44
ok let me test this one, thanks a lot.... if you know any software that I can use please let me know
Tony  2010-10-19 18:08:58

related questions

SQL Server, convert a named instance to default instance?
Natural (human alpha-numeric) sort in Microsoft SQL 2005
In MS SQL Server 2005, is there a way to export, the complete maintenance plan of a database as a SQL Script?
Does ReadUncommitted imply NoLock
Query to list all tables that contain a specific column with SQL Server 2005.
Can I maintain state between calls to a SQL Server UDF?
What are the benefits of using partitions with the Enterprise edition of SQL 2005
Upgrading Sharepoint 3.0 to SQL 2005 Backend?
What's the simplest way to execute a query in Visual C++
Can you perform an AND search of keywords using FREETEXT() on SQL Server 2005?
Create a database from another database?
What's the fastest way to bulk insert a lot of data in SQL Server (C# client)
SQL 2005 Book For Optimization Techniques
How do I create a mapping table in SQL Server Management Studio?
Cannot Add a Sql Server Login
SQL Server 2005 - Export table programatically (run a .sql file to rebuild it)
Diagnosing Deadlocks in SQL Server 2005
SQL2005: Linking a table to multiple tables and retaining Ref Integrity?
How to create a new instance of Sql Server 2005
SQL Server 2008 vs 2005 Linq integration
How do you kill all current connections to a SQL Server 2005 database?
Conditional Visibility and Page Breaks with SQL Server 2005 Reporting Services
SQL Server 2005 and 2008 on same developer machine?
Paging SQL Server 2005 Results
SQL 2005 For XML Explicit - Need help formatting