Replicate or split database, which is better or more manageable?

  • Thread starter Thread starter Patrick
  • Start date Start date
P

Patrick

I have read chapter about database replication couple
times and still not sure if this is what I really want to
do.
I have come across, in the newsgroups, on discussion of
database splitter and tried it on the copy of my database
and it works. I have 3 question regarding
replicate/database splitter:
1: between database replication / database splitter,
which one is better.
2: if I choose to split the database, will it be okay
to put back-end database on the folder
called "Database_be" and put front-end database in the
folder called "Database" on the same LAN network rather
than putting the actual front-end database on user's
computer.
3: if I choose to split the database, will it affect
the database referential integrity?

I greatly appreciate anyone input. Thank you in advance.

Patrick,
 
1. Unles you have users that need the data when not conncted to the LAN,
replication should not even be considered.
2. If you do this, you still have multiple users access the same file.
While its better than not splitting, it is still not optimal. Network
traffic will be higher than if you put FE on each user's machine.
3. No. Your RI is defined in the BE file (where the tables are).

--
Kevin Hill
President
3NF Consulting

www.3nf-inc.com/NewsGroups.htm
 
Back
Top