| From: | "Jason Uberig" <uberjay(at)hotmail(dot)com> |
|---|---|
| To: | <pgadmin-support(at)postgresql(dot)org> |
| Subject: | Prob. with migration plugin wrt. MS SQL source DB |
| Date: | 2002-11-20 18:28:41 |
| Message-ID: | OE42dLLJ0y0gheMjp1T0000179e@hotmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgadmin-support |
Hello, in trying to run the migration tool on a fairly large MS SQL DB I am receiving the following error:
-------------------------------------
Creating table: NDF__COMPANY_MARKETING_CONTACTS
Creating sequence NDF__COMPANY_MARKETING_CONTACTS_NDF__ID_key
An error occured at: 20/11/2002 12:27:47 PM:
-2147467259: ERROR: Relation 'NDF__COMPANY_MARKETING_CONTACTS' already exists
Rolling back... Done.
-------------------------------------
From MS SQL (2000) the SQL of the table is as follows:
-------------------------------------
CREATE TABLE [dbo].[NDF__COMPANY_MARKETING_CONTACTS] (
[NDF__ID] [int] IDENTITY (1, 1) NOT NULL ,
[CONTACTS_ID] [int] NULL ,
[COMPANIES_ID] [int] NULL ,
[NDF_VALUE] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[NDF__COMPANY_MARKETING_CONTACTS] WITH NOCHECK ADD
CONSTRAINT [PK_NDF__COMPANY_MARKETING_CONTACTS] PRIMARY KEY CLUSTERED
(
[NDF__ID]
) ON [PRIMARY]
GO
-------------------------------------
It seems like there might be some limitation on the length of a relation's identifier. That is, it looks as if the sequence name is getting truncated.
Any thoughts? Is this something with the migration plugin or pgadmin or postgresql??
Thanks for any help!
Jason.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | c f | 2002-11-20 20:46:18 | problems seeing all objects v1.4.0 |
| Previous Message | Dave Page | 2002-11-20 16:09:38 | Re: pgAdmin 1.4.0 Released |