I have a problem copying data and structures from Pervasive 8.5 to MSSQL 2000. I use DTS and everything works fine except for the index's and foreign keys. They are simply NOT copied. The creation of tables and data are OK, but FK and indexes are not copied. How should I solve this problem?


Darlok

Have you looked at DataJunction (http://pervasive.datajunction.com/solutions)? Looks like it might be a good tool.