Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
SVK
Starting Member
2 Posts |
 Posted - 2005-08-11 : 05:51:51
|
| HI,My query is as follows :I have a database which has to be replicated with another database. I have achieved this through sql replication and works fine.I also have a folder structure with files(word , pdf , excel etc..) on the web server which are associated with particular rows in a particular table in the database. These files also have to be replicated with the same folder structure. How do I initiate a file replication which is in sync with the data replication of sql.Any help is much appreciated.Thanks |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2005-08-11 : 15:54:55
|
| SQL Server does not support file replication.Tara |
 |
|
|
SVK
Starting Member
2 Posts |
Posted - 2005-08-16 : 06:32:18
|
| Is there no way that I can do this ? |
|
|
|
mblythe
Starting Member
16 Posts |
Posted - 2005-08-16 : 12:14:10
|
| It is possible to do if you write a custom app; it's just not supported natively by SQL Server. The app would need to know which rows have changed at the Subscriber since the last synch, and then copy the file associated with each changed row over the network (creating directories as necessary).Michael Blythe Technical WriterSQL Server Replication - Microsoft --------------------------------------------------------------------------- This posting is provided "AS IS" with no warranties, and confers no rights. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2005-08-16 : 12:14:19
|
| Not with SQL Server. File replication will need to be handled by some other product.Tara |
|
|
|
|
|
|
SQL REPLICATION AND FILE REPLICATION