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

    import data from one database ta another for same schema

    sdba

      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.