Procedure to Remap Tables

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,

I have a database which is operating in a production environment. There are
around 6 backends, I want to set up a replicated development environment.
This should be fairly easy, a bit of work but easy enough.

Ideally when I publish new releases the the production environment, I'd like
to just be able to switch a flag which would re-point all my front end, back
end links to the production backends. Anyone know a way of doing this, or any
previous lessons any doing this. Any help would be appreciated.

Cheers

Neil
 
you could add a table to the frontend db, with one record for each filepath
to each backend db. if the "production" backend dbs are all in the same
folder, and the "development" backends are also in one folder, then you
could get by with two records in the table - one record for each filepath.
add a second field to designate each record as "production" or
"development".

then just add a public module to delete all the linked tables, and then
re-link them, pulling the filepath from the table according to whether you
want a production link or a development link.

hth
 
Back
Top