Solved

Folder Replication

Posted on 2016-09-23
4
45 Views
Last Modified: 2016-09-29
There is a back-end server that has a folder with database files. Can anyone recommend a real-time replication on the folder level? I believe the database is flat and proprietary.
0
Comment
Question by:exhuser
4 Comments
 
LVL 39

Expert Comment

by:lcohan
ID: 41813079
"back-end server that has a folder with database files" - what database server is that - SQL Server?
0
 

Author Comment

by:exhuser
ID: 41813184
No, I believe it is a "flat" custom-built database.
0
 
LVL 7

Expert Comment

by:Mohamed Khairy
ID: 41813190
0
 
LVL 56

Accepted Solution

by:
Cliff Galiher earned 500 total points
ID: 41813194
I *never* recommend using folder-based replication on database files. Even "flat" (whatever that means to you) requires special handling.  Technically dBase from back in the day was just file-based. As was early implementations of the Jet engine (think Microsoft Access)  ...and yet copying them without being application aware still caused corruption. But dBase and Access support transactions, and you can copy a file mid-transaction and all hell breaks loose.

You really need to work with the database vendor to make sure you get this done right. Otherwise that "copy" is as worthless as a piece of coal in a field of diamonds.
0

Featured Post

What Security Threats Are You Missing?

Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

Join & Write a Comment

New Windows 7 Installations take days for Windows-Updates to show up and install. This can easily be fixed. I have finally decided to write an article because this seems to get asked several times a day lately. This Article and the Links apply to…
OfficeMate Freezes on login or does not load after login credentials are input.
This tutorial will walk an individual through the process of transferring the five major, necessary Active Directory Roles, commonly referred to as the FSMO roles to another domain controller. Log onto the new domain controller with a user account t…
This tutorial will show how to configure a single USB drive with a separate folder for each day of the week. This will allow each of the backups to be kept separate preventing the previous day’s backup from being overwritten. The USB drive must be s…

760 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

22 Experts available now in Live!

Get 1:1 Help Now