Drop FK constarints

The simplest way to populate your database with test data.

Drop FK constarints

Postby tilo23 » Mon Jan 16, 2012 12: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 2:56 pm
Location: Berkshire, UK

Postby james.billings » Tue Jan 17, 2012 5: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: 1122
Joined: Wed Jun 16, 2010 10:10 am
Location: Red Gate

Another Vote for FK data control

Postby sgiJim » Wed Feb 01, 2012 8: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 8:06 pm
Location: Saint Louis, Mo

Postby james.billings » Wed Feb 01, 2012 8: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: 1122
Joined: Wed Jun 16, 2010 10:10 am
Location: Red Gate

Return to SQL Data Generator Previous Versions

Who is online

Users browsing this forum: No registered users and 0 guests