RE: Domain Move and Data Integrity

2001-02-28 Thread Eric Barr
: 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

Re: Domain Move and Data Integrity

2001-02-28 Thread Tony Schreiber
1) You could prevent updates/deletes to the old (Access database) OR 2) You could have the new hosting and database setup and have the old website access it as a remote datasource (via IP) Little bit off topic, but I wanted to ask people who uses ColdFusion to develop sites with database.

Domain Move and Data Integrity

2001-02-27 Thread river
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,

RE: Domain Move and Data Integrity

2001-02-27 Thread James Maltby
age- From: river [mailto:[EMAIL PROTECTED]] Sent: 27 February 2001 15:29 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

RE: Domain Move and Data Integrity

2001-02-27 Thread James Maltby
What I meant to say is http refer the old site to the new ip address - which should be live before the DNS updates happen. J -Original Message- From: river [mailto:[EMAIL PROTECTED]] Sent: 27 February 2001 15:29 To: CF-Talk Subject: Domain Move and Data Integrity Little bit off topic

RE: Domain Move and Data Integrity

2001-02-27 Thread David Schmidt
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

Re: Domain Move and Data Integrity

2001-02-27 Thread Jay Patton
ot; [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 data

Re: Domain Move and Data Integrity

2001-02-27 Thread Dick Applebaum
I usually handle it this way: 1. set the New site to transfer back to the old site (meta tag, Javascript, CFLocation) 2. Submit the domain change 3. wait several days (a week?) 4. freeze changes to old site 5. Copy old site db to New site 6. test new site 7. Kill transfer from New back

RE: Domain Move and Data Integrity

2001-02-27 Thread Elizabeth Marcotte - Selphcotte Web Designs
:[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

RE: Domain Move and Data Integrity

2001-02-27 Thread Aidan Whitehall
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

RE: Domain Move and Data Integrity

2001-02-27 Thread Aaron Johnson
Aaron Johnson, MCSE, MCP+I Allaire Certified ColdFusion Developer MINDSEYE, Inc. phn617.350.0339 fax617.350.8884 icq66172567 [EMAIL PROTECTED] -Original Message- From: Aidan Whitehall [mailto:[EMAIL PROTECTED]] Sent: Tuesday, February 27, 2001 12:39 PM To: CF-Talk Subject: RE: Domain Mov

RE: Domain Move and Data Integrity

2001-02-27 Thread Philip Arnold - ASP
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. Here's a few other

RE: Domain Move and Data Integrity

2001-02-27 Thread Tony Schreiber
The problem you described below would not occur if you set the server on the old address to access the datasource on the new address. Two sites yes, but only one datasource. Couldn't you just point the DSN on the access side to the SQL db until the change takes place? I've got a