Comments
Sort by recent activity
Yes, it's only useful for scenarios with /synchronize - the reports don't contain the information because we haven't had that many requests to update them with static data. In your case, you should probably use the SQL Data Compare command line to report on the data differences. The deployment script output is just the SQL that would need to be executed to make the changes. You could possibly reconstruct the differences from that, but it sounds like it would just be easier to use both command lines in your case. / comments
Yes, it's only useful for scenarios with /synchronize - the reports don't contain the information because we haven't had that many requests to update them with static data.In your case, you should ...
/include:StaticData should include the static data in the deployment script output if your source is a SQL Source Control scripts folder. It won't include the static data in any reporting, and there's no SQL Compare UI equivalent - it's really just there to simplify automation so that you don't have to use two different command lines when deploying with static data from SQL Source Control. I'll attempt to make it clearer in the documentation. What were your expectations of the /reportAllObjectsWithDifferences flag that it did not satisfy? / comments
/include:StaticData should include the static data in the deployment script output if your source is a SQL Source Control scripts folder. It won't include the static data in any reporting, and ther...
Usually this is a case sensitivity problem (the database is case sensitive but the option 'Treat items as case sensitive' is off, causing two objects to appear to have the same name).
You could also turn on logging (from the 'icon menu', the menu from the SQL Compare icon in the top left-hand corner) and see at what stage in the registration process the exception is being thrown, which might tell you which object is causing the problem. / comments
Usually this is a case sensitivity problem (the database is case sensitive but the option 'Treat items as case sensitive' is off, causing two objects to appear to have the same name).
You could als...
The option will ignore the role memberships in the comparison but it doesn't affect the registration yet. It's on our feature request list to make the option affect registration as well as comparison (as SC-4267) but it isn't implemented yet. / comments
The option will ignore the role memberships in the comparison but it doesn't affect the registration yet. It's on our feature request list to make the option affect registration as well as comparis...
Probably only when we drop support for SQL Server 2000 and/or it stops working at all in a new version.
What are the advantages of changing it to UPDATE / WRITE from your perspective? / comments
Probably only when we drop support for SQL Server 2000 and/or it stops working at all in a new version.
What are the advantages of changing it to UPDATE / WRITE from your perspective?
Filters are in the main screen so that it's easier to change them and get immediate feedback - because they don't need to be considered during database registration, they can be more easily changed while looking at the comparison results than most of the other comparison-affecting project options. I've made a note that we should consider having some kind of link from the project options dialog here, though. / comments
Filters are in the main screen so that it's easier to change them and get immediate feedback - because they don't need to be considered during database registration, they can be more easily changed...
It looks like what you want to do is actually filter out the role object type? (Open the filter sidebar from the '0 objects filtered' button on the button bar, then uncheck 'Role' from the list.) Or if you want to filter out this particular role rather than all roles, you can click on the blue pen icon that appears when you hover over the 'role' checkbox to specify name-based rules for filtering out roles. / comments
It looks like what you want to do is actually filter out the role object type? (Open the filter sidebar from the '0 objects filtered' button on the button bar, then uncheck 'Role' from the list.)Or...
You can either send it to me, michelle.taylor@red-gate.com, and I'll get around to looking at it at some point, or if you want a more formal process you can send it to support at support@red-gate.com and they'll make sure they get back to you in a reasonable time [image] . / comments
You can either send it to me, michelle.taylor@red-gate.com, and I'll get around to looking at it at some point, or if you want a more formal process you can send it to support at support@red-gate.c...
I've seen this happen very occasionally - it's caused by some exception getting up to the control which provides the main grid.
Is this problem repeatable for you? Can you give any details about what kind of data sources you were using, what path you took through the synchronization wizard, etc?
Did you have logging on and could you send us the relevant part of the log file? (You can find the logging functionality in the 'icon menu' - the menu that comes up when you click on the SQL Compare icon in the top left corner of the window.) / comments
I've seen this happen very occasionally - it's caused by some exception getting up to the control which provides the main grid.
Is this problem repeatable for you? Can you give any details about wh...
Yes - you can set the RGTEMP environment variable. See https://documentation.red-gate.com/display/SDC13/Getting+better+performance+out+of+SQL+Data+Compare for more details. / comments
Yes - you can set the RGTEMP environment variable. See https://documentation.red-gate.com/display/SDC13/Getting+better+performance+out+of+SQL+Data+Compare for more details.