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

Command line option toinclude FG, PS and PF

I can't find the command line option to include "Filegroups, Partition schemes and Partition Functions" when synchronizing 2 databases.
Using the GUI, it works fine by unchecking this option in the "ignore"-list (edit project - options-tab)
Simply said: how can I include Partitioning functions, schemes and partitions usage in table and index creation included into my command line SQL Compare process?
Geert Vanhove
0

Comments

2 comments

Sort by
  • Brian Donahue
    There is a SQL Compare option called IgnoreFileGroups (or ifg) that will do the same as SQL Compare. So you can add /options:Default,ifg and that should combine the default option with IgnoreFileGroups.

    If you're concerned about differences between the commandline and the UI, you can always have the command-line run a SQL Compare project file instead.
    Brian Donahue
    0
  • Geert Vanhove
    I found the solution using /options:None.
    The issue I had was related to the filegroup that was missing at the db level, when I created this one manually, using /options:None created also my partitionScheme and function
    Geert Vanhove
    0

Add comment

Please sign in to leave a comment.