Comments
Sort by recent activity
There should be a seperate item in your SQL Toolbelt Installer called 'SSMS Integration Pack 1.0' - re-installing that specifically might help?
If you're still having trouble, we're currently looking into improvements to SSMS integration so hopefully we can get to the bottom of what's wrong with it for you - it doesn't currently work with the SQL Server 2012 version of Management Studio, for instance, which we should have fixed in a couple of weeks. / comments
There should be a seperate item in your SQL Toolbelt Installer called 'SSMS Integration Pack 1.0' - re-installing that specifically might help?
If you're still having trouble, we're currently looki...
There's a project option for this - if you look at the Options tab of the Edit Project dialog, there's an option named 'Force Column Order'. If you uncheck the box next to that option, your comparison should ignore column order in tables. / comments
There's a project option for this - if you look at the Options tab of the Edit Project dialog, there's an option named 'Force Column Order'. If you uncheck the box next to that option, your compari...
You can specify an actual name for the constraint (e.g. 'col1 CONSTRAINT unique_constraint_x UNIQUE' instead of just 'col1 UNIQUE') when creating the constraint, but there's no global way to force SQL Server to change its automatic naming scheme.
IgnoreConstraintNames ought to have ignored constraint names during comparison (i.e. it won't flag the table as different if the only difference is the constraint name), but if there is another difference on the table then it will attempt to synchronize the constraint name when it synchronizes the table.
If you don't care what the constraint name is, this ought to be harmless (as it should also update any references to that constraint with the new name if you've included dependencies). / comments
You can specify an actual name for the constraint (e.g. 'col1 CONSTRAINT unique_constraint_x UNIQUE' instead of just 'col1 UNIQUE') when creating the constraint, but there's no global way to force ...
...it looks like you have a square bracket in the object name. Is that the case?
If so, that's a known issue (SC-3375) which I've now added your report to - I'm not sure what the timescale for fixing it is, alas. / comments
...it looks like you have a square bracket in the object name. Is that the case?
If so, that's a known issue (SC-3375) which I've now added your report to - I'm not sure what the timescale for fixi...
You can already filter out tables starting with a particular string using the filter panel (which shows up when you press the filter button on the toolbar).
Unfortunately there's no way to currently filter out individual columns for any reason - table comparisons are all-or-nothing. / comments
You can already filter out tables starting with a particular string using the filter panel (which shows up when you press the filter button on the toolbar).
Unfortunately there's no way to currentl...
By default, new objects are not selected for synchronization, to help avoid accidental synchronizations. So any object which your project hasn't seen before will show up with an empty check box.
If you customarily synchronize everything it should be fine to just check everything - you can use the check boxes in the grouping bars to check/uncheck everything in the group, or the one in the column headings row to check/uncheck everything in the comparison.
This was changed from previous versions which would select everything by default due to requests from some people who found the 'always select new objects' behaviour dangerous.
Does that answer your question? / comments
By default, new objects are not selected for synchronization, to help avoid accidental synchronizations. So any object which your project hasn't seen before will show up with an empty check box.
If...
You might be able to work around the problem for now by applying the Ignore Users' Permissions And Role Memberships option (and unchecking that user if it appears as a difference in its own right) if you don't have any permissions / roles that you actually want to synchronize.
If that doesn't work, you could try also unselecting 'include dependencies' in the synchronization wizard, although that might end up with the script not working for other reasons. / comments
You might be able to work around the problem for now by applying the Ignore Users' Permissions And Role Memberships option (and unchecking that user if it appears as a difference in its own right) ...
I generally work around this problem by taking the script and running it in SSMS, which will tell me all the errors (although sometimes with some bonus ones from previous operations being rolled back). / comments
I generally work around this problem by taking the script and running it in SSMS, which will tell me all the errors (although sometimes with some bonus ones from previous operations being rolled ba...
Not currently, but we're working on an option to fix it (probably by synchronizing it as char rather than nchar data in the first place, possibly by enhancing the comparison code to deal with the situation).
(The reason that it turns into unicode is that when we synchronize any string value currently we use the N'' notation to ensure no information is lost, but while SQL Server will automatically convert that back down to single-byte characters in a varchar column, it will keep it as double-byte characters when putting it in a sqlvariant column.) / comments
Not currently, but we're working on an option to fix it (probably by synchronizing it as char rather than nchar data in the first place, possibly by enhancing the comparison code to deal with the s...
You can exclude column order changes by unchecking the 'Force Column Order' option in the options tab of the project configuration dialog (the one you get from Create Project or Edit Project).
I don't believe there currently is a way to copy and paste the whole list using the GUI. If you have the Pro version, you could use the command line's 'include' switch to include just that list of tables, but that will only give you a command line report of the differences.
If you can give an example of how to reproduce the problem with pasting from the filter (do you mean the 'new/edit filter' dialog, or the search box? If you're talking about the filter dialog, which text box within that?) we'll have a look at it. / comments
You can exclude column order changes by unchecking the 'Force Column Order' option in the options tab of the project configuration dialog (the one you get from Create Project or Edit Project).
I do...