This is one of the prime reasons not to use an Access or file-based
database. If you use SQL Server, or any client server DB, you simply point
the new DSN to the new SQL server. Both sites can now use the same
database. No hassles. No updates. No "merging" of data.
But let's put it another way. There is constant discussion of how Access is
cheaper to use... let's say in this situation that it costs you 5 to 10
hours to manage the entire process of moving, merging, talking with client,
talking with hosting provider to manage the transition. Let's also say that
you bill $50 an hour (which is low)... We're talking about anywhere from
$250 to $500 of billable time ONLY because you're using Access. How much is
SQL per month? $50? Does it make sense yet to move away from Access to SQL?
Just a thought, I'm not trying to say Access isn't right for "some"
things...
Aaron Johnson, MCSE, MCP+I
Allaire Certified ColdFusion Developer
MINDSEYE, Inc.
<phn>617.350.0339
<fax>617.350.8884
<icq>66172567
[EMAIL PROTECTED]
-----Original Message-----
From: Aidan Whitehall [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, February 27, 2001 12:39 PM
To: CF-Talk
Subject: RE: Domain Move and Data Integrity
> Couldn't you just point the DSN on the access side to the SQL
> db until the
> change takes place?
I've got a similar problem.
A site is in on a server at IP address 123.0.0.10 (for example).
You move the site to a different server (at the same host or not - doesn't
make a difference) on IP 218.03.10.50
You alter the DNS entries.
Users connect to the Internet via ISPa. ISPa caches domain names so that it
resolves to 123.0.0.10 until the TTL kicks in (cognoscenti - is this how it
works?). Those users hit the site and add / modify / delete data to the
database on 123.0.0.10.
Other users connect to the Inter via ISPb. ISPb refreshes their domain name
cache earlier. Their users hit the site at 218.03.10.50 and add / modify /
delete data to the database on that server.
End result - Host1 has a database with some new entries. Host2 has a
database with some new entries.
Someone (ie the developer) has to go and mop up the differences and compile
them into the database on Host2.
Q: How can you prevent this situation arising without taking the site
completely offline until ISPb has updated their domain name cache?
Anwsers on a postcard...
--
Aidan Whitehall <[EMAIL PROTECTED]>
Netshopper UK Ltd
Advanced Web Solutions & Services
http://www.netshopperuk.com/
Telephone +44 (01744) 648650
Fax +44 (01744) 648651
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
