migration SQL 6.5 to SQL 7

migration SQL 6.5 to SQL 7

Post by Neil Pik » Sat, 04 Nov 2000 04:00:00



 Mindy - no you shouldn't in almost all cases - but see the SQL 7 BOL for
differences in the products

 > Do I have to change embeded SQL statement from application after I migrate

Quote:> to SQL Server 7.0 with compatibility level 70?

> Thanks.

> Mindy

 Neil Pike MVP/MCSE.  Protech Computing Ltd
 Reply here - no email
 SQL FAQ (484 entries) see
 http://forumsb.compuserve.com/gvforums/UK/default.asp?SRV=MSDevApps
 (faqxxx.zip in lib 7)
 or www.ntfaq.com/Articles/Index.cfm?DepartmentID=800
 or www.sqlserverfaq.com
 or www.mssqlserver.com/faq
 
 
 

migration SQL 6.5 to SQL 7

Post by Mindy Zhan » Sun, 05 Nov 2000 01:46:22


Hi,

Do I have to change embeded SQL statement from application after I migrate
to SQL Server 7.0 with compatibility level 70?

Thanks.

Mindy

 
 
 

1. Migration SQl 6.5 to SQl 2000

Felix,

The DTS Import wizard in SQL 2k doesn't work for this?

/Lasse


I am encountering problems migrating the following code from 6.5 to 2000
The main block is the replace of 6.5 syslocks table with 2000 syslockinfo
table
Can somebody provide some help about how to change the following 6.5
compatible
select statement to SQL 2000::

SELECT SLG.Name, SO.name, SP2.program_name, SP2.hostname
FROM master.dbo.syslogins SLG, master.dbo.sysprocesses SP1,
     master.dbo.sysprocesses SP2, master.dbo.syslocks SLCK, dbo.sysobjects
SO

      AND SP2.SPID = SLCK.SPID AND SLCK.id = SO.id

2. Converting CS+ to Excel

3. Application Login Failure After SQL 6.5 to 6.5 data migration

4. SQL Programming Class

5. SQL 6.5 to SQL 2000 migration issues

6. USA-415- DBA'S, DEVELOPERS NEEDED

7. Migration of a base SQL 6.5 towards SQL 7.0

8. Paradox 7 and FAT32

9. *** Need Help With Migration from SQL 6.5 to SQL 7.0***

10. Migration from SQL 6.5 to SQL 7.0 to eliminate blocking.txt

11. Migration: SQL Server 6.5 to SQL Server 2000

12. Migration of a base SQL 6.5 towards SQL 7.0

13. Migration SQL SERVER 4.2 DATA TO SQL SERVER 6.5