Migration SQl 6.5 to SQl 2000

Migration SQl 6.5 to SQl 2000

Post by Lasse Edsvi » Fri, 02 Mar 2001 18:47:59



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

 
 
 

1. SQL 6.5 to SQL 2000 migration issues

Are there any known issues out there regarding migrating
data from a SQL 6.5 server to a SQL 2000 server?

We are setting up a new SQL 2000 server and need to
migrate the data from 6.5 to 2000...just wanted to know if
anybody had ever heard of any issues?

Thx,

Phil

2. Reports...

3. Migration: SQL Server 6.5 to SQL Server 2000

4. Help with connection to local analysis server

5. migration sql 6.5 SQL 2000

6. Trapping ESCAPE in dBase

7. Migration SQL 6.5 ->2000 Server

8. Question of syntax with SQLMAINT.EXE

9. Migration from 6.5 to sql 2000

10. Migration between SQL 6.5 and 2000

11. SQL 2000 (SBS) to SQL 2000 (Proper) Migration

12. Migration from Pervasive SQL 2000 to MS-SQL Server 2000 using ADO

13. SQL 6.5 vs. SQL 7.0 or SQL 2000