Migration from SQL 7 to SQL 2000
-
Hello.
We're in the process of migrating from SQL 7 to SQL 2000.
We've pointed out some T-SQL differences between these two versions :
- old non-SQL92 joins : *= and =* (unsupported on 2000),
- implicit datatypes conversion diseases,
- old = NULL comparison replaced by IS NULL systematically,
- ORDER BY #number clause may be unsupported in future versions...
I don't know if this list is exhaustive and I need some help to achieve the job as painless as possible. Every tool, document, information would be useful and greatly appreciated.
Thank you all by advance.
Gaël
-
Hello,
Supported or not *= and =* works just fine in SQL 2000. I just finished testing. One area that you may want to examine is BCP, version differences seem to handle things like trailing spaces diferently.
Best wishes,
Barry O'Connell
-
Hello Barry. Thank you for your quick reply.When you're saying that old-fashioned non-ansi joins are working, did you test in a compatibility level 80 database ?
-
Hello,
I spent a month testing dozens of scripts, dbs, jobs, etc… for a national company. The majority of the code had been written for SQL Server 6.5. The test environment was 8.0 running on 2000 servers all patched to the latest patch as of 4/1/04. Non-ANSI outer joins were a particular concern so I tested those extensively. The only difference between my 7.0 on 2000 test environment was that if a sort order was not specified in the query the order of the data might be different. However the data was always the same. 7.0 needs more RAM to run faster than 7.0. When both servers were configured the same 7.0 was faster.
Best wishes,
Barry O’Connell
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply