2 way split

  • Thread starter Thread starter Amy Blankenship
  • Start date Start date
A

Amy Blankenship

I have a fe/be setup, but I'd actually like to do a further split to
separate data that changes nearly constantly (and is populated
automatically) from data that is relatively static that needs to be
maintained by a person. What's the best way to accomplish a 3-way split?

-Amy
 
Amy said:
I have a fe/be setup, but I'd actually like to do a further split to
separate data that changes nearly constantly (and is populated
automatically) from data that is relatively static that needs to be
maintained by a person. What's the best way to accomplish a 3-way
split?
-Amy
Click to expand...

A front end can link to as many back ends as you want. One problem though is
that you cannot enforce referential integrity between tables that don't exist in
the same file.

Just import the desired tables into a new back end file, delete them from the
current back end file, delete the current links in the front end for those
tables and create new links to the new back end file.
 
OK, thanks. Now to figure out how to get everything to reconnect in
different environments...
 
Loosing RI is an important consideration. I would recommend NOT splitting
the tables into several databases unless you were running into size issues
and couldn't contain all the data in a single database.
 
Back
Top