REQ: Limit number of "Duplicate Key ignored" messages

The simplest way to populate your database with test data.

Moderators: David Atkinson, Anu Deshpande, Lionel

REQ: Limit number of "Duplicate Key ignored" messages

Postby tkdennis » Fri May 23, 2008 5:04 am

Could the final report at the end limit the number of times "Duplicate Key Ingored" message is printed. I'm using the suggested work around IGNORE_DUP_KEY on the primary key to avoid the generator stopping (http://www.red-gate.com/messageboard/vi ... noredupkey)
and getting several pages worth.

Thanks,
Traci
tkdennis
 
Posts: 75
Joined: Fri Feb 29, 2008 1:13 am

Postby benhall » Fri May 23, 2008 11:35 am

Hello,

Are you getting the message multiple times per table or just once per table but for lots of tables?

So I can log the feature for review, what would you like to be displayed on the report? Where would you like to be able to disable the message?

Thanks

Ben
benhall
 
Posts: 69
Joined: Fri Dec 14, 2007 11:15 am

Postby tkdennis » Fri May 23, 2008 1:39 pm

It's multiple times per table. Ideally, I'd like one line that said "Duplicate key ignored 10,000 times"

If it needs to be disabled, then both at the table level and in the Project Edit option as the default setting for all tables.

Thanks,
Traci
tkdennis
 
Posts: 75
Joined: Fri Feb 29, 2008 1:13 am


Return to SQL Data Generator 1

Who is online

Users browsing this forum: No registered users and 0 guests