I'm attempting to use the Generate Scripts feature of SQL Server Management Studio in order to script the schema and data of a database which has Node and Edge tables included. When I select Schema and Data for Types of data to script in the Advanced options, I get the following exception, shown in the post-script failure report:
System.Data.SqlClient.SqlException:
Cannot access internal graph column 'graph_id_65236D8A22184389B40ACEF8C7BA629D'
Is this a bug?
How can I use the Generate Scripts feature to script both schema and data for a database containing graph objects in SQL Server 2017?
You should upgrade SSMS to the newest version:
Release notes for SQL Server Management Studio (SSMS)
SSMS 18.1
SMO/scripting
Fixed an issue where "Generate Script" on a graph table fails when generating data. See UserVoice for more details.