SQL server native replication tool to replicate database with graph tables

Question

We are using “SQL Server 2019 Enterprise” database and OS is “Windows server 2019 standard” with SQL server native replication tool to replicate database with graph tables.

In source database, we have SQL Graph tables as well (like Node,Edge etc). we have following question:

1. Does SQL server native replication tool support graph table replication?
2. If not, then what native tool or steps do microsoft recommend and please provide steps?

Answer 1

I tried to google around, but I did not find many hits that mentioned both. That's a good sign, because that would mean there is no document saying that this combo is not supported. Then again, there are a wee bit too many situations when "advanced" features in SQL Server do not play well together.

I think you should set up a test. If if fails, open a support case, if nothing else to get a final answer "not supported". Then again, if it works, that does not prove that it is supported, but it could work by chance. You would find out if it breaks some day and you open a case, and you are told. Then again, if that happens, I'd say it is a bug that they did not stop you.

Answer 2

Hi @Mukesh Ojha

Yes, as Erland said, I also didn't find clear documentation stating SQL server native replication tool support graph table replication. The official documentation only says that the graphics extension is fully integrated into the SQL Server database engine.

For more details, you can refer to this link: https://learn.microsoft.com/en-us/sql/relational-databases/graphs/sql-graph-overview?view=sql-server-ver16.

Best regards,

Aniya