Environment versions
Network:
Windows Server 2012 R2
>At that low bandwidth at the branches, having a connection via Citrix would be the way to go and only have one central server. Trying to replicate over that low bandwidth will be trouble for that data volume potential.
>
>Yes, it turns out the solution provider isn't willing to support replication over low bandwidth, so it's going to have to be some sort of remote access setup.
>
>Embedding documents in the database doesn't happen every day. They might go for a while not doing any, and then have to put in one or two dozen.
>
>Do you have any idea of the efficiency of replication in this sort of scenario? If a 1MB document is embedded, how large of a transaction log entry does that create - I wonder if there's significant bloat.
Sorry, but my experience here is lacking. I have always stored the documents external to the database into a protected folder location. If you are concerned with security, then you could store the documents into a password protected zip file with the password stored encrypted into the database with the file name (the file location is a configuration parameter for me).
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only