Devart Forums

Hello, I have a question regarding schema compare for MS SQL Server.
Is it possible to exclude some tables from comparison process or from generated synchronization script while doing it through command line?

Thanks

Thanks for the post.
Yes, you can. First of all create a new comparison and exclude objects. Then save the comparison document to the disk. Then you can start dbForge Schema Comparer from command line using "/compfile " option to specify the tuned comparison.

Aha. I see. And should I recreate this .comp file every time I have my schema changed (in case then excluded tables stay the same but some new table appears)?

I just found that scom is an xml file and it contains only excluded table. This answers on my second question.

Thanks for help. Schema compare is really great.

We plan to add the "Include objects by mask" and "Exclude objects by mask" options in the next version. With the help of these options you will be able to specify the objects that should be excluded from comparison (mapping) and the objects that should be forcibly included into comparison using regular expressions. That means you will be able to do this visually and without hacking XML file.

Cool. It would be very useful.

By the way Does anybody know why schemacompare.com cant be run with ant task or directly with java spawn command?

ivan wrote:By the way Does anybody know why schemacompare.com cant be run with ant task or directly with java spawn command?

To run Schema Compare via command line in Scheduled Task, you should specify complete paths to the files. If there are spaces in names, you should write them in quotes.
To make working with command line more comfortable, you can create a *.bat file with the run command, and then open this file to run the program via command line. For example, you can insert the following line to the run.bat file:

Yes. I created a bat file. It runs directly without any problems but it cant be run from ant. It doesnt show any error messages just skips a command.