Moving db from SQL 6.5 to SQL 2000

Moving db from SQL 6.5 to SQL 2000

Post by THVrZ » Sat, 07 Feb 2004 03:16:08



Hello

I' ve to recreate/export a database which at the moment is on 6.5 to SQL Server 2000.
I've used Data Transformation Services Import/Export Wizard of 2000 to get the data from 6.5
I've got all the tables with the data, but I've checked the users and noticed that some specific users are not there. I only have dbo. Why
Do I have now to create them manually
How can I be sure that I've imported all the tables/all the objects, Groups/Users and data correctly?
Is there a better method

Thank you for you help
Kind regard
Luk