Prob. with migration plugin wrt. MS SQL source DB

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: Raw Message | Whole Thread | 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.

Browse pgadmin-support by date

  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