Bug #13286 | Tables in SQL Server having composite foreign keys not migrated | ||
---|---|---|---|
Submitted: | 16 Sep 2005 22:01 | Modified: | 26 Oct 2005 22:12 |
Reporter: | Krishnan Ganapathy | Email Updates: | |
Status: | Can't repeat | Impact on me: | |
Category: | MySQL Migration Toolkit | Severity: | S1 (Critical) |
Version: | Release 5.0.X | OS: | Windows (Windows, Linux) |
Assigned to: | CPU Architecture: | Any |
[16 Sep 2005 22:01]
Krishnan Ganapathy
[21 Sep 2005 17:59]
Jorge del Conde
Thank you for your bug report. I was able to reproduce this bug by using the supplied table definitions under 1.0.18
[19 Oct 2005 13:02]
Michael G. Zinner
I could not verify this. Can you please paste the complete script to create the master and detail table? I tested with 1.0.19 and this script. if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[FK_product_part_product]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1) ALTER TABLE [dbo].[product_part] DROP CONSTRAINT FK_product_part_product GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[product_part]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[product_part] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[product]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[product] GO CREATE TABLE [dbo].[product] ( [idproduct_group] [int] NOT NULL , [idproduct] [int] NOT NULL , [name] [char] (10) COLLATE Latin1_General_CI_AS NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[product_part] ( [idproduct_part] [int] NOT NULL , [idproduct_group] [int] NOT NULL , [idproudct] [int] NOT NULL ) ON [PRIMARY] GO ALTER TABLE [dbo].[product] WITH NOCHECK ADD CONSTRAINT [PK_product] PRIMARY KEY CLUSTERED ( [idproduct_group], [idproduct] ) ON [PRIMARY] GO ALTER TABLE [dbo].[product_part] WITH NOCHECK ADD CONSTRAINT [PK_product_part] PRIMARY KEY CLUSTERED ( [idproduct_part] ) ON [PRIMARY] GO ALTER TABLE [dbo].[product_part] ADD CONSTRAINT [FK_product_part_product] FOREIGN KEY ( [idproduct_group], [idproudct] ) REFERENCES [dbo].[product] ( [idproduct_group], [idproduct] ) GO
[26 Oct 2005 22:11]
Jorge del Conde
I was unable to reproduce this bug using the last MT release.
[27 Oct 2005 13:47]
Krishnan Ganapathy
The error i suppose is with the Migration Toolkit. I have given the script that we have used in the description of the bug. Is there a later version of the Migration Toolkt that have corrected this bug? Pls let me know. We are still trying with the Version we have is ver 1.0.15.