February 16, 2006 at 6:44 pm
I am attempting to upgrade an old server from SQL Server 6.5 to 2000.
One of the informational files that was created in the upgrade server subdirectory at the end of my upgrade attempt was "Differences Report.txt"
One of the headings in the report is "Columns in 8.0, but not in 6.5". This part of the report is listing out the columns for quite a number of tables (but not all the tables) in one of the databases being upgraded. When I checked a couple of the tables (and their respective columns) listed in the report, everything seemed fine. Before checking the entire contents of this section of the report, I attempted to look on microsoft.com and the internet for an explanation of this section of the report but could not find anything. Does anyone know what is meant by "Columns in 8.0, but not in 6.5"? Is this something to be concerned about?
Thanks in advance for any help anyone can provide.
February 17, 2006 at 8:58 am
Are these user tables? Maybe reserved words for the column names?
February 17, 2006 at 12:53 pm
Thanks for your reply Steve. These are user tables, but a randon check of some of them shows that reserved words are not being used for the column names. In the upgrade directory there is a file called dbcheck.sql. In that file I noticed a reference to "Columns in 8.0, but not in 6.5". I suspect the upgrade wizard must execute the dbcheck.sql script, but I'm still having a difficult time interpreting what is meant by the "Columns in 8.0, but not in 6.5" section in the "Differences Report".
February 22, 2006 at 8:26 am
What is commonly known as SQL Server 2000 is REALLY SQL Server 8.0. So that statement can be translated to "Columns in SQL Server 2000, but not in SQL Server 6.5". To help you understand it more, we would have to know the whole statement.
-SQLBill
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply