Recently, I migrated the database from NT/SQL SERVER 6.5 to WIN2K/SQLSERVER 2000. During this migration all the data was transferred correctly, but all the indexes, constraints, and keys were dropped. Is this is a known bug in this type of migration or did anyone run into similar situation? I have many more databases to be migrated with similar setup. Any suggestions per precautions?
Would appreciate any help!
Thanks,
-RP