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
DBForge Schema Compare
Re: DBForge Schema Compare
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
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
-
- Posts: 2
- Joined: Tue 25 Jun 2019 23:58
Re: DBForge Schema Compare
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)
Re: DBForge Schema Compare
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.
We collect and analyze the information from this forum in order to make a proper roadmap for the future product releases.