Command line option toinclude FG, PS and PF

Compares and synchronizes SQL Server databases, backups and scripts.

Moderators: JonathanWatts, Chris Auckland, David Atkinson, eddie davis, Anu Deshpande, Michelle Taylor, alice.easey, james.billings, chengvoon.tong

Command line option toinclude FG, PS and PF

Postby Geert Vanhove » Tue Mar 27, 2012 4:03 pm

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
 
Posts: 5
Joined: Thu Oct 20, 2011 3:23 pm

Postby Brian Donahue » Wed Mar 28, 2012 2:21 pm

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
 
Posts: 6670
Joined: Mon Aug 23, 2004 10:48 am

Postby Geert Vanhove » Wed Mar 28, 2012 3:17 pm

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
 
Posts: 5
Joined: Thu Oct 20, 2011 3:23 pm


Return to SQL Compare 10

Who is online

Users browsing this forum: No registered users and 0 guests