Ben
Thanks for your comments. I feel more confident heading into this project.
Thanks,
* John *
--- "Benjamin S. Rogers" <[EMAIL PROTECTED]> wrote:
> 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/cf-talk@houseoffusion.com/
> 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/cf-talk@houseoffusion.com/
> 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.
__________________________________________________
Do You Yahoo!?
Kick off your party with Yahoo! Invites.
http://invites.yahoo.com/
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
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.
