All in all, it was one of the smoothest upgrades (of that relative
magnitude) I've ever done. We upgraded about 20 or so databases of varying
size and complexity. The only issues we ran into were the fault of bad
programming on the developer's part.
Some badly designed SQL Queries quit running after the upgrade. On the
average, each query took only a moment to fix. For instance, the SQL Server
7 syntax validator seems to be a little more judicious about what it will
let pass: SQL Server 6.5 only seems to check whether or not a character,
word or phrase is allowed but not necessarily the syntax in which it is used
(e.g. stray semi-colons).
The only other issue we had was also the fault of bad programming on the
developer's side. Some of our developers got into the bad habit of using
some reserved words. If I remember correctly, SQL Server prefixed an
underscore to column names named after a word that SQL Server 7 put into use
(e.g. "Date"). Where we got hit the hardest was with a table that was named
"Logins." I don't believe "Logins" was on the reserved list, but SQL Server
7 adds several more system tables to each database, one of which is called
"Logins." In this instance, the data simply did not transfer. We had to
import the data separately into a table of a different name, change a few
foreign key constraints, and change the SQL queries that used the table.
None of which was terribly difficult.
Anyway, everything you need to perform the upgrade should be on the SQL
Server 7 CD ROM. After the upgrade, you'll just have to test your sites and
monitor the ColdFusion error logs to determine what errors are occurring
because of the upgrade. The SQL Server upgrade utility will notify you upon
completion if any data fails to transfer from SQL Server for whatever
reason. I believe it pipes it out to a text file, if I remember correctly.
In any case, go for it. In our collective opinion, SQL Server 7 is a vastly
superior product. In our situation it solved far more problems than it
caused.
Benjamin S. Rogers
Web Developer, c4.net
voice: (508) 240-0051
fax: (508) 240-0057
-----Original Message-----
From: JB Mentzer [mailto:[EMAIL PROTECTED]]
Sent: Monday, August 07, 2000 3:59 PM
To: [EMAIL PROTECTED]
Subject: Upgrading SQL 6.5 - 7.0?
Hi
Has anyone on list overseen a project to upgrade a CF site's SQL backend
from v6.5 to 7.0?
I've been asked to quote a price for this project ... and haven't a clue
what this entails (I'm familiar with SQL 7, but not 6.5)
Any advice/related experience would be greatly appreciated.
* john *
----------------------------------------------------------------------------
--
Archives: http://www.mail-archive.com/[email protected]/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/[email protected]/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
