Re: Import & Export DB table structure with data

From: vinny <vinny(at)xs4all(dot)nl>
To: Ashwani Kumar B <ashwani(dot)b(dot)kumar(at)ericsson(dot)com>
Cc: pgsql-performance-owner(at)postgresql(dot)org, pgsql-sql-owner(at)postgresql(dot)org, pgsql-admin(at)postgresql(dot)org, pgsql-admin-owner(at)postgresql(dot)org
Subject: Re: Import & Export DB table structure with data
Date: 2017-07-19 07:16:46
Message-ID: acea877f29cff5f22b97b6ff0192018f@xs4all.nl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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.

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Ashwani Kumar B 2017-07-19 07:18:28 Re: Import & Export DB table structure with data
Previous Message Ashwani Kumar B 2017-07-19 07:14:32 Re: Import & Export DB table structure with data