I would like to compare two schemas in the same SQL server Database

Via Toad, (version 8.1.0.28168) I would like to compare two schemas in the same SQL server Database. I have a DEV and TEST schema in the same DB i would like to compare. I can compare two schemas in different DBs but i am issues trying compare in the same DB.

Hi Donald,

Toad for SQL Server is not designed for this use case, only schemas from two different databases canbe selected as source and target for the schema comparison function.

I would suggest creating a copy of that database so you can compare these two schemas through the Schema Compare function within the tool.

1 Like