UK software company, Redgate, has released its new version of SQL Compare, supporting graph databases in SQL Server.

The Release Candidate 2 version of SQL Server 2017 includes new graph database capabilities for modelling many-to-many relationships.

SQL Compare v13 fully supports this, allowing users to compare and deploy databases, which include both graph and relational tables.

SQL Graph in SQL Server 2017 allows users to use a single query across graph and relational objects.

‘Supporting temporal and retention tables’

Jamie Wallis, Redgate product marketing manager, said: “Microsoft has taken a big step forward with SQL Server 2017.

“SQL Graph gives users more options on the same platform and our new SQL Compare release reassures them they can still make error-free deployments.

“When users upgrade to SQL Server 2017 they can explore all of the new features while knowing the industry-standard for comparing and deploying databases won’t let them down.”

As well as support for connections to SQL Server instances on Linux, and Azure Active Directory authentication, the release also supports other features in SQL Server 2017, such as temporal and retention tables.

Written from press release by Leah Alger