I have two schemas which are exactly the same. Does anyone know how i can copy the data from one database to the other. The problem i have experinced is that the IDs generated by the schema in one database are the same as the other database but these ids link the rows with other tables.

Does anyojne know a way of being able to do this, easily?

Thanks