Aidan,
Jay was saying DSN not DNS ... he was suggesting changing the ODBC
connection that the old site uses and point it to the database on the
new site.
But, going this route could cause some problems....if their is an upsize
from Access to SQL happening, their is most likely going to be some SQL
on the old site that will not work on the new site. In addition, if the
new site is setup behind a firewall or at least has the DB server on a
non-routable segment of the network ....the old site will not be able to
reach the new DB directly.
Regards,
-eric
------------------------------------------------
Common sense is genius dressed in its working clothes.
-- Ralph Waldo Emerson
Eric Barr
Zeff Design
(p) 212.714.6390
(f) 212.580.7181
-----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/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
