Fillfactor on command line getting ignored
rre
Posts: 42 Bronze 2
Hi there,
I am using SQL Compare for comparing my database with a script folder. One of my tables is using an index with a fillfactor. Unfortunately SQL Compare ignores this index option by using the command line tool.
It also doesn't helped to create a ComparisonOptions.xml in the snapshot directory by disabling the option "IgnoreFillfactor". My index will always be created without the fillfactor I have specified.
SQL Server: SQL Server 12.0.2430
SQL Compare Version: SQL Compare 11.2.0.22
Do you could help me on this?
Regards
Robert
I am using SQL Compare for comparing my database with a script folder. One of my tables is using an index with a fillfactor. Unfortunately SQL Compare ignores this index option by using the command line tool.
It also doesn't helped to create a ComparisonOptions.xml in the snapshot directory by disabling the option "IgnoreFillfactor". My index will always be created without the fillfactor I have specified.
SQL Server: SQL Server 12.0.2430
SQL Compare Version: SQL Compare 11.2.0.22
Do you could help me on this?
Regards
Robert
Comments
When using the command line, you'll need to set options using the /Options switch instead of a ComparisonOptions.xml file (I believe the latter is only used by SQL Source Control)
This page has more details: http://documentation.red-gate.com/displ ... mmand+line - hope it's helpful
You're right with my mix-up with the ComaprisonOptions.xml file.