Options

Drop FK constarints

tilo23tilo23 Posts: 27
edited February 1, 2012 3:19PM in SQL Data Generator Previous Versions
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
· Share on Twitter

Comments

  • Options
    James BJames B Posts: 1,124 Silver 4
    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.
    Systems Software Engineer

    Redgate Software

    · Share on Twitter
  • Options
    sgiJimsgiJim Posts: 1
    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

    Submarines.
    · Share on Twitter
  • Options
    James BJames B Posts: 1,124 Silver 4
    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.
    Systems Software Engineer

    Redgate Software

    · Share on Twitter
Sign In or Register to comment.