From: | "Henshall, Stuart - Design & Print" <SHenshall(at)westcountry-design-print(dot)co(dot)uk> |
---|---|
To: | 'Reshat Sabiq' <sabiq(at)purdue(dot)edu>, pgsql-novice(at)postgresql(dot)org |
Subject: | Re: moving a postgreSQL DB, etc. |
Date: | 2002-11-04 16:25:50 |
Message-ID: | E2870D8CE1CCD311BAF50008C71EDE8E0506DC90@MAIL_EXCHANGE |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
Henshall, Stuart - Design & Print wrote:
> Reshat Sabiq wrote:
>> Hi,
>>
>> I wonder if it is as easy to move a postgreSQL DB from one machine to
>> another (assuming both are using postgre) as dumping it into a file,
>> ftping the file, and loading it on the other end.
>>
>> P.S. Is there an easy way to import an Access DB into postgreSQL?
>> P.P.S. Is there a tool similar to Access that provides visual DB
>> interface for postgre DBs. P.P.P.S. Is it easy to import a postgreSQL
>> into a different one, like Oracle, or MS SQL Server?
>>
>> Thanks,
>> r.
> You just dump the database using pg_dump (or pg_dumpall for all db's
> and users) to dump the database. If you have just made a plain dump
> you can just use psql to restore. http://pgadmin.postgresql.org site
> has a tool called pgMigration available for download. This should
> help. I've not transfered data the other way, but if you use copy to
> get the data to a tab seperated file then it should be ok, or just
> link through ODBC and suck up the data directly (I think SQL Server
> has a tool to do this). hth,
> - Stuart
Sorry to reply to myself, just a quick addendum:
there is a program called pgaccess which I havn't used, but believe to be
designed to give a similar style enviroment.
Alternativley you can access a postgreSQL db from MS Access using ODBC.
- Stuart
From | Date | Subject | |
---|---|---|---|
Next Message | Nick Sayer | 2002-11-04 18:02:38 | Re: Populating a database |
Previous Message | Henshall, Stuart - Design & Print | 2002-11-04 16:23:06 | Re: moving a postgreSQL DB, etc. |