Red Gate forums :: View topic - Data Generator fails on bridge table
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Data Generator 1
SQL Data Generator 1 forum

Data Generator fails on bridge table

Search in SQL Data Generator 1 forum
Post new topic   Reply to topic
Jump to:  
Author Message
emmanuelbuah



Joined: 22 Oct 2010
Posts: 4

PostPosted: Fri Oct 22, 2010 6:54 pm    Post subject: Data Generator fails on bridge table Reply with quote

Below is my table structure for which im trying to generate test data. I have the project configured to generate 1 business, 7 businessgroups , 1000 businessmemebers and 1500 businessgroupmembers. Business, businessgroup and businessmember generates without error but businessgroupmembers fails. Is this a bug or I'm missing something here.


Code:

/****** Object:  Table [dbo].[Business]    Script Date: 10/22/2010 07:58:14 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[Business](
   [BusinessId] [int] IDENTITY(1,1) NOT NULL,
 CONSTRAINT [Business_PK] PRIMARY KEY CLUSTERED
(
   [BusinessId] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]

GO



/****** Object:  Table [dbo].[BusinessGroup]    Script Date: 10/22/2010 07:58:29 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[BusinessGroup](
   [BusinessId] [int] NOT NULL,
   [BusinessGroupId] [int] IDENTITY(1,1) NOT NULL,
 CONSTRAINT [PK_BusinessGroup] PRIMARY KEY CLUSTERED
(
   [BusinessId] ASC,
   [BusinessGroupId] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]

GO

ALTER TABLE [dbo].[BusinessGroup]  WITH NOCHECK ADD  CONSTRAINT [Business_FK_BusinessGroup] FOREIGN KEY([BusinessId])
REFERENCES [dbo].[Business] ([BusinessId])
GO

ALTER TABLE [dbo].[BusinessGroup] CHECK CONSTRAINT [Business_FK_BusinessGroup]
GO




/****** Object:  Table [dbo].[BusinessGroupMember]    Script Date: 10/22/2010 07:58:40 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[BusinessGroupMember](
   [BusinessMemberId] [int] NOT NULL,
   [BusinessGroupId] [int] NOT NULL,
   [BusinessGroupBusinessId] [int] NOT NULL,
   [BusinessMemberBusinessId] [int] NOT NULL
) ON [PRIMARY]

GO

ALTER TABLE [dbo].[BusinessGroupMember]  WITH NOCHECK ADD  CONSTRAINT [FK_BusinessGroupMember_BusinessGroup1] FOREIGN KEY([BusinessGroupBusinessId], [BusinessGroupId])
REFERENCES [dbo].[BusinessGroup] ([BusinessId], [BusinessGroupId])
GO

ALTER TABLE [dbo].[BusinessGroupMember] CHECK CONSTRAINT [FK_BusinessGroupMember_BusinessGroup1]
GO

ALTER TABLE [dbo].[BusinessGroupMember]  WITH NOCHECK ADD  CONSTRAINT [FK_BusinessGroupMember_BusinessMember] FOREIGN KEY([BusinessMemberBusinessId], [BusinessMemberId])
REFERENCES [dbo].[BusinessMember] ([BusinessId], [BusinessMemberId])
GO

ALTER TABLE [dbo].[BusinessGroupMember] CHECK CONSTRAINT [FK_BusinessGroupMember_BusinessMember]
GO


USE [WorkSpace]
GO

/****** Object:  Table [dbo].[BusinessMember]    Script Date: 10/22/2010 07:58:48 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[BusinessMember](
   [BusinessId] [int] NOT NULL,
   [BusinessMemberId] [int] IDENTITY(1,1) NOT NULL,
 CONSTRAINT [PK_BusinessMember_1] PRIMARY KEY CLUSTERED
(
   [BusinessId] ASC,
   [BusinessMemberId] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]

GO

ALTER TABLE [dbo].[BusinessMember]  WITH NOCHECK ADD  CONSTRAINT [Business_FK_BusinessMember] FOREIGN KEY([BusinessId])
REFERENCES [dbo].[Business] ([BusinessId])
GO

ALTER TABLE [dbo].[BusinessMember] CHECK CONSTRAINT [Business_FK_BusinessMember]
GO

Back to top
View user's profile Send private message
james.billings



Joined: 16 Jun 2010
Posts: 1113
Location: My desk.

PostPosted: Mon Oct 25, 2010 2:30 pm    Post subject: Reply with quote

I've opened you a support ticket and contacted you directly to work through this - let me know if you don't get the email!
Back to top
View user's profile Send private message
emmanuelbuah



Joined: 22 Oct 2010
Posts: 4

PostPosted: Mon Oct 25, 2010 2:55 pm    Post subject: Reply with quote

I received the email but it only said someone will contact me so I don't know if I'm suppose to wait. I haven't received any direct email from you James. I received one email and that was from support. Let me know.
Back to top
View user's profile Send private message
james.billings



Joined: 16 Jun 2010
Posts: 1113
Location: My desk.

PostPosted: Mon Oct 25, 2010 3:00 pm    Post subject: Reply with quote

OK - I was basically after your data generator project file, as I tried to replicate the problem but got different results. Could you reply to the auto-email with that, and also the error you were seeing?

Thanks!
Back to top
View user's profile Send private message
emmanuelbuah



Joined: 22 Oct 2010
Posts: 4

PostPosted: Mon Oct 25, 2010 11:36 pm    Post subject: Reply with quote

I replied the support email with attached zip files of the data gen file and pdf file of the error. Thanks.
Back to top
View user's profile Send private message
james.billings



Joined: 16 Jun 2010
Posts: 1113
Location: My desk.

PostPosted: Tue Oct 26, 2010 11:13 am    Post subject: Reply with quote

We've received those, thanks - I'll take a look
Back to top
View user's profile Send private message
emmanuelbuah



Joined: 22 Oct 2010
Posts: 4

PostPosted: Thu Oct 28, 2010 5:09 pm    Post subject: Reply with quote

James, any luck on whether this is a bug or setup/configuration issue on my part.
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group