What are untrusted constraints and what action needs taken to rectify?



  • Link: https://docs.microsoft.com/en-us/sql/dma/dma-bestpractices?view=sql-server-ver15

    Check for untrusted constraints on both the source database and the target database before migrating data.

    What are untrusted constraints? And what does check for untrusted constrains mean? Check specifically what and what action is to be taken?



  • A foreign key that was created or updated using WITH NOCHECK. Basically, the data in the tables isn't validated, so there's no way of knowing if the data is accurate to the constraint or not. https://www.bing.com/ck/a?!&&p=e3fa8392df85137c88a810a55aabc8c9e4892f5170d182c55e02c2e7dd5b94d1JmltdHM9MTY0OTg1NTM2NiZpZ3VpZD04NDc4MjZhYi02NjQ3LTRlOTEtOWFlNy01NDdlNzZhYWVmZjImaW5zaWQ9NTE2OQ&ptn=3&fclid=f1f3dacb-bb2a-11ec-b2bd-8a808285d739&u=a1aHR0cHM6Ly9kYXRhYmFzZS5ndWlkZS93aGF0LXlvdS1zaG91bGQta25vdy1hYm91dC13aXRoLW5vY2hlY2std2hlbi1lbmFibGluZy1hLWNoZWNrLWNvbnN0cmFpbnQtaW4tc3FsLXNlcnZlci8_bXNjbGtpZD1mMWYzZGFjYmJiMmExMWVjYjJiZDhhODA4Mjg1ZDczOQ&ntb=1 .


Log in to reply
 


Suggested Topics

  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2