On 2017-07-19 07:55, Ashwani Kumar B wrote: > Hi > > I have to import table structure from one DB and create the same > table structure in another DB. > > Secondly I have to copy all the data from one DB to another DB > > Kindly suggest way forward. > > Regards > > Ashwani
If both databases are PostgreSQL then you can just use pg_dump.
If the databases are of different brands then you may need special tool, there are many conversion tools available, but not all free or inexpensive.