Devart Forums

Hi Members,

I am trying to evaluate Schema Compare tool for our organization & this tool looks good but I have below concerns.

We generate our reports from command line so Is there any way I can add object filter to command line so I can exclude some of the objects when running the compare like users,roles & schemas etc .I dont see option for object filter when I generate "save command Line".I do have option for comparison options but it just have the filters of options

You could use the 'ExcludeObjectsByMask', 'IgnoreColumnsByMask', 'IncludeObjectsByMas' options:
https://docs.devart.com/studio-for-sql- ... mpare.html
https://docs.devart.com/studio-for-sql- ... mpare.html

Also, the *.scomp/*.dcomp file generated in the GUI of dbForge can be used in the command line. It will store the settings you made when generating the file:
https://docs.devart.com/studio-for-sql- ... s-cmd.html
https://docs.devart.com/studio-for-sql- ... a-cmd.html

Thanks Alexa for your response.I was able to get schema compare report by using .scomp file.Is there any way the comparison report generated can be Interactive html report?(If I click on object can it show difference in schema lime missing columns,data type difference etc)

There is no such a possibility. Though, you can vote for the following suggestion on the UserVoice forum https://devart.uservoice.com/forums/177 ... in-sql-sch

We collect and analyze the information from this forum in order to make a proper roadmap for the future product releases.