Drop FK constarints

The simplest way to populate your database with test data.

Moderators: David Atkinson, Anu Deshpande, Lionel

Drop FK constarints

Postby tilo23 » Mon Jan 16, 2012 1:02 pm

Is there any way to tweak the project so it didn't concern on FK constraints regarding particular columns? I've seen many posts regarding more options to modify foreign keys in Data Generator, I was thinking it could be possible if I modify XML behind the project. Cannot find the appropriate line though...
Inside the Dilbert's world
Posts: 19
Joined: Thu Dec 22, 2011 3:56 pm
Location: Berkshire, UK

Postby james.billings » Tue Jan 17, 2012 6:27 pm

SQL Data Compare will always select the FK generator if it detects FK relationships on the column.

The only way around this is to drop the relationship in the database first. You can't work around it by editing the config file.

You are right, we have several requests to improve the FK abilities, but unfortunately we've not made changes in this area just yet.
Posts: 1144
Joined: Wed Jun 16, 2010 11:10 am
Location: My desk.

Another Vote for FK data control

Postby sgiJim » Wed Feb 01, 2012 9:17 pm

Sadly, without the ability to control and manipulate foreign key data, the Generator does not meet our needs. :(

Badly I made the assumption we could and told my boss it was so. :oops:
During WWII, 66% of Japanese Merchant Ships and 33% of War Ships were sunk by one branch of the Navy, a branch that was just 2% of the total Navy manpower and ships, that branch was

Posts: 1
Joined: Wed Feb 01, 2012 9:06 pm
Location: Saint Louis, Mo

Postby james.billings » Wed Feb 01, 2012 9:19 pm

I'm sorry to hear that - I'm hoping the FK generator will become more configurable in the future but I have no timescales or guarantees.

If you purchased the product and it's not suitable for your needs then you may want to discuss a refund with our sales team.
Posts: 1144
Joined: Wed Jun 16, 2010 11:10 am
Location: My desk.

Return to SQL Data Generator 1

Who is online

Users browsing this forum: No registered users and 0 guests