RE: Domain Move and Data Integrity

[Elizabeth Marcotte - Selphcotte Web Designs]

River,

We just went through this situation.  The previous comments are right on.

1) Point the old site to the new database at the new hosting company (you
can do this with the IP of the new hosting company)
2) Have the old hosting site re-direct the IP address to the new hosting
site (when you are fully tested with the new site).  The old hosting company
can do a name server change so the customer will see your .com name and not
the IP address it is re-directing to.  Make sure you all links are relative.
3) Do the domain registration modification request.
This will have the effect that everyone will be using the same database.
Depending on the propagating time for the domain modification, they are
either accessing your site through the old site or through the new site.
Eventually, everyone will be on the new site.

Good luck,
Elizabeth

-----Original Message-----
From: river [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, February 27, 2001 7:29 AM
To: CF-Talk
Subject: Domain Move and Data Integrity

Little bit off topic, but I wanted to ask people who uses ColdFusion to
develop sites with database.

Here is the situation:
I need to move a site to another hosting.  The site has a database and that
needs to be upgraded from Access to SQL.  When the domain registration
modification takes place, it takes more than a couple of days to propagate
through the net.  So, some people will access the old site that connects to
the Access database, and some people will access the new one that connects
to SQL.  Consequently, from the time the propagation starts to the time it
finishes, there will be new data on both the databases.

The integrity of the database is kept on the coding side and not on the
database side, and I can't simply add the new data on Access to SQL by
importing.

What would people usually do in this kind of situation?

I appreciate any kind of suggestions/inputs/ideas!
Thanks in advance.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
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