How can we help you today? How can we help you today?

Fillfactor on command line getting ignored

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
rre
0

Comments

2 comments

Sort by
  • Mark J
    Hi,

    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
    Mark J
    0
  • rre
    Thx to Mark. This solved my issue.

    You're right with my mix-up with the ComaprisonOptions.xml file.
    rre
    0

Add comment

Please sign in to leave a comment.