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.
|