8 Replies Latest reply: Jan 30, 2014 2:51 AM by sdba RSS

    import data from one database ta another for same schema


      I have two dbs A and B.

      both have User U.

      User U have two tables:

      Parent(Colums Id primary key,Name ,Attributes).

      Child (columns id primary key,Name,attributes,PID foreign key refering id column of parent table).


      Now I want to import data for these two tables from Database A to B.

      Only new data should be added or old data should be updated.

      no delete are permitted and sequence of id's should be consecutive.


      Please suggest some ways.