| Author |
Message |
Geert Vanhove
Joined: 20 Oct 2011 Posts: 5
|
Posted: Tue Mar 27, 2012 4:03 pm Post subject: 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? |
|
| Back to top |
|
 |
Brian Donahue
Joined: 23 Aug 2004 Posts: 6348 Location: Red Gate Software
|
Posted: Wed Mar 28, 2012 2:21 pm Post subject: |
|
|
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
Technical Support
Red Gate Software Ltd.
44 (0)870 160 0037 ext 8521
US and CAN 1-866-RED GATE ext 8521 |
|
| Back to top |
|
 |
Geert Vanhove
Joined: 20 Oct 2011 Posts: 5
|
Posted: Wed Mar 28, 2012 3:17 pm Post subject: |
|
|
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 |
|
| Back to top |
|
 |
|
|
All times are GMT + 1 Hour
|
| Page 1 of 1 |
|
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum
|
Powered by phpBB © 2001, 2005 phpBB Group