| From: | "Dave Page" <dpage(at)vale-housing(dot)co(dot)uk> |
|---|---|
| To: | "Kurt Roeckx" <Q(at)ping(dot)be>, <pgadmin-hackers(at)postgresql(dot)org> |
| Subject: | Re: Using COPY in the migration wizard. |
| Date: | 2002-12-11 22:19:22 |
| Message-ID: | 03AF4E498C591348A42FC93DEA9661B8128D50@mail.vale-housing.co.uk |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgadmin-hackers |
> -----Original Message-----
> From: Kurt Roeckx [mailto:Q(at)ping(dot)be]
> Sent: 11 December 2002 22:12
> To: pgadmin-hackers(at)postgresql(dot)org
> Subject: [pgadmin-hackers] Using COPY in the migration wizard.
>
>
> The migration wizard is very slow because it does an insert
> of all the records. Would it be possible to use COPY instead?
No because there is no interface for copy in the ODBC spec.
> What I can do in psql in less than a second takes 10 minutes
> or more using the wizard. That is just for one of the
> smallest tables. For the whole database it's probably going
> to take days at this rate.
Make sure you have logging turned off under Tools -> Options, and that
SQL tracing is switched of in the ODBC driver manager. To be honest
though, if you can get your data in a format for copy, then I would
suggest migrating the empty tables only using pgAdmin, then loading them
using psql.
Regards, Dave.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Kurt Roeckx | 2002-12-11 22:25:03 | Re: Using COPY in the migration wizard. |
| Previous Message | Kurt Roeckx | 2002-12-11 22:11:47 | Using COPY in the migration wizard. |