anxious! Wait online! Problems with data import / export! Brothers enlighten me!

ddtddt

My previous database did not have foreign keys. Now I have to add them. After I add them, I generate a database through ERWIN. When importing data from the previous database, I always prompt foreign key conflicts. What indexes are not allowed What kind of errors can I solve? And there are some triggers in my database. Will they be affected when I import data?

ddtddt

Has anyone encountered this problem before?

cinaese

Index, see if it is the only index, if it is, you can not import the value that already exists in the index column in the table

There is also a foreign key. If you are importing into a slave table and the value of the foreign key does not exist in the master table, the system will also prohibit the import

The solution is to delete the index and relationship first, and then insert and then import the data. If you want to create the same index and relationship again, please check the value of the column to be uniquely indexed. Change the same value