| From: | "Nigel J(dot) Andrews" <nandrews(at)investsystems(dot)co(dot)uk> |
|---|---|
| To: | Tapan Trivedi <ttrivedi(at)webifyservices(dot)com> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Migration from SQLServer |
| Date: | 2003-05-16 08:38:52 |
| Message-ID: | Pine.LNX.4.21.0305160937000.30690-100000@ponder.fairway2k.co.uk |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Fri, 16 May 2003, Nigel J. Andrews wrote:
> On Fri, 16 May 2003, Tapan Trivedi wrote:
>
> > b. Create script. Let me explain - I generated the script from MSSQL and
> > it gave a whole lot of issues (for SQL statements and types) . When I
> > resolved all of them, I encountered Relation ".." not found error. The
> > only way I could resolve it was by giving the table names in quotes. I
> > guess I should have converted all table names in lowercase and then all
> > would be OK.
> >
> > What I am trying to find out now is - Is there anyway I can avoid
> > dropping the database and recreating it ??
>
> Sure, take a look at relname in pg_class and typname in pg_type. The other
> columns in those table will help you decide who owns what and what schema
> they're in so you can change only those ones you want to.
Oh, and don't forget to start a transaction before making the changes so that
you get the chance to rollback if you make a mistake, these are system tables.
--
Nigel Andrews
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tapan Trivedi | 2003-05-16 08:49:06 | Re: Migration from SQLServer |
| Previous Message | Nigel J. Andrews | 2003-05-16 08:32:15 | Re: Migration from SQLServer |