Couldn't you just point the DSN on the access side to the SQL db until the
change takes place?
Jay Patton
Web Design / Application Design
Web Pro USA
406.549.3337 ext. 203
1.888.5WEBPRO
www.webpro-usa.com
----- Original Message -----
From: "river" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Tuesday, February 27, 2001 8:28 AM
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/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
