Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Multi-Site Database Replication - SQL Server
Message
From
29/04/2017 04:49:23
Walter Meester
HoogkarspelNetherlands
 
 
To
29/04/2017 03:24:42
General information
Forum:
Visual FoxPro
Category:
Client/server
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows 7
Network:
Windows Server 2012 R2
Database:
MS SQL Server
Application:
Desktop
Miscellaneous
Thread ID:
01650658
Message ID:
01650666
Views:
44
>>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.

BTW, I would not care about the transactionlog... if backups are made everyday, it should not not reach significant size, unless you're doing a large number of large transactions
Previous
Reply
Map
View

Click here to load this message in the networking platform