none
Cannot generate SQL deploy script : SQL72002: Edge tables may contain references to nodes from RRS feed

  • Question

  • On a SQL 2017 database

    I cannot generate the SCRIPT script required to do a database publish

    I am getting the following error: SQL72002: Edge tables may contain references to nodes from [dbo].[TableName]

    In VS, the script is generated but there is an indication dans it failed

    Tried latest version of SSDT for VS 2017 (15.9.1) and sqlpackage (18.2) (ref: https://docs.microsoft.com/en-us/sql/tools/release-notes-sqlpackage?view=sql-server-2017)

    Is this a sqlpackage option that I should be using to help with the deployment of edge tables?

    A new column was being added to the graph table (+ new ones)

    Current workaround was to dropped the table (a truncate of it's data was not sufficient)

    Thanks.


    • Edited by Bhuard Friday, July 5, 2019 5:14 PM
    Wednesday, July 3, 2019 3:55 PM

All replies

  • I believe this question is probably not posted in the proper forum

    Is there a VS forum equivalent for SQL (as there do give status and responses when I log there)

    Where do I submit SQL issues?

    Thanks

    Wednesday, July 10, 2019 6:35 PM