search

schemacrawler / SchemaCrawler

Free database schema discovery and comprehension tool
http://www.schemacrawler.com/
Other
1.62k stars 199 forks source link

Enhancement: To be able to specify report color/disable coloring by name #84

Closed pyrocks closed 8 years ago

pyrocks commented 8 years ago

Hi,

The reason I want this is because our schema are named [basename][version]

In example SCHEMA1_0100 and SCHEMA1_0200 I want to be able to compare between them since it's the same schema - just different versions of it - without the color specifications coming up on the diff.

Either way - to be able to specify report color/disable coloring by name - is good for my purposes.

Thanks again, Mor

schemacrawler commented 8 years ago

Please use SchemaCrawler 14.09.03. You will need to set a new configuration value in your properties file, schemacrawler.format.no_schema_colors=true

pyrocks commented 8 years ago

Thanks a lot, I will test it later today.

pyrocks commented 8 years ago

New configuration value is working correctly, :+1: .

schemacrawler commented 8 years ago

Excellent.

pyrocks commented 8 years ago

Hi, Another question - when comparing 2 HTMLS I get different "span id" values for the same object (table). Any way to avoid that? Thanks

schemacrawler commented 8 years ago

Mor, you cannot avoid different span id values. SchemaCrawler needs to ensure that the id is unique, and it does that by deriving the id based off the fully qualified database object name. What you can do, though, is to generate output in text format, and compare that.

pyrocks commented 8 years ago

I thought about that - then I might have to generate 2 type of files (1 for readability and another for compare). will check that. Thanks.

schemacrawler commented 8 years ago

That may be a good idea. The HTML compare can get messy if you do not have a good compare tool. If you do use a good HTML compare tool, it should be able to filter out mismatches between ids.