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.