Print

---

Hi

Has anyone got a blockboard 5 and blackboard 6 system which should match
after a migration?  Is so the following SQL script may be usefull to see if
any content is missing (we use SQL 2000 on Windows 2000).

select
        distinct bb5cm.course_id
from
        bb_bb60.dbo.course_contents bb6cc
        right outer join
        bb50.dbo.course_contents bb5cc
        on bb5cc.pk1 = bb6cc.pk1
        inner join
        bb50.dbo.course_main bb5cm
        on bb5cm.pk1 = bb5cc.crsmain_pk1
where
        bb6cc.pk1 is NULL
        and
        bb5cc.folder_ind = 'N'
        and
        bb5cm.course_id not like 'TEMP_%'
order by
        bb5cm.course_id

You need access to both databases and can modify the where clause to
excluded any courses you have filtered.

Please let me know if anyone finds any problems as we are currently finding
content missing.  Also please let me know if you find any problems or
improve the SQL script.

Thanks
Ray Glendenning
Northumbria Learning