changing a one to one left join to a many to one ?

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • jamie
    Senior Member
    • Aug 2025
    • 103

    #1

    changing a one to one left join to a many to one ?

    Is this sort of thing even possible?

    In the past, someone set up the relationship, and we now have a lot of data relying on it, but our database has just grown too big, so our query time has exceeded the timeout point, and we need to change it, but we don't want to lose data

    Thanks for all the help and even snide remarks
  • emillod
    Active Community Member
    • Apr 2017
    • 1499

    #2
    It's possible to change it via files. Proper change should be applied via entityDefs directory, BUT it require also adjustments in database, so there should be a script which will adjust data. It's possible, but it's tricky and without skills may cause data loss.

    Comment

    • jamie
      Senior Member
      • Aug 2025
      • 103

      #3
      Originally posted by emillod
      It's possible to change it via files. Proper change should be applied via entityDefs directory, BUT it require also adjustments in database, so there should be a script which will adjust data. It's possible, but it's tricky and without skills may cause data loss.
      yeah greater ablity to switch between types would be amazing, luckly this time i could just delete it

      Comment

      • emillod
        Active Community Member
        • Apr 2017
        • 1499

        #4
        It's possible, but it's more advanced process, so it shouldn't be available via GUI imho.

        Comment

        Working...