Comments
Sort by recent activity
Hi Patrick,
The feature request is logged as SC-4520. Can I ask whether you're looking to compare the same source database with different targets? i.e., you only need the second data source to override the /project selection, not the first?
Thanks!
David Atkinson
Product Manager
Red Gate Software / comments
Hi Patrick,
The feature request is logged as SC-4520. Can I ask whether you're looking to compare the same source database with different targets? i.e., you only need the second data source to over...
New major version upgrades require a re-activation. Provided this is from the same machine and you have a valid support and upgrades contract this will not use up a new activation so please feel free to go ahead.
I'll pass this feedback to our technical author as it would seem sensible to document this somewhere!
Kind regards,
David Atkinson
Product Manager
Red Gate Software / comments
New major version upgrades require a re-activation. Provided this is from the same machine and you have a valid support and upgrades contract this will not use up a new activation so please feel fr...
Hi,
Thanks for the feedback. Can I ask what it is about the 'data sources' dialog that makes you want to resize it? Is there information that would be better viewed if it were expanded?
The SQL Differences window _is_ fully resizable so I'm a little confused. You first have to undock it otherwise it only resizes vertically. Please give this a go and let me know how you get on.
Kind regards,
David Atkinson
Red Gate Software / comments
Hi,
Thanks for the feedback. Can I ask what it is about the 'data sources' dialog that makes you want to resize it? Is there information that would be better viewed if it were expanded?
The SQL Dif...
Unfortunately it's not possible to synchronize one column at a time as SQL Compare works at the table scope. The workaround is to generate the script and amend it manually.
I've noted your request and we'll consider this in a future release.
Kind regards,
David Atkinson
Product Manager
Red Gate Software / comments
Unfortunately it's not possible to synchronize one column at a time as SQL Compare works at the table scope. The workaround is to generate the script and amend it manually.
I've noted your request ...
Thanks for the feedback.
1) This is a fair point. Could you describe a situation where you would want to just create the scripts? I suppose the option could be added to the File menu like it is in SQL Compare.
2) The selections in Tables & Views are used to determine which tables should be treated as static data. Is there somewhere else this should be expressed/indicated?
Thanks,
David Atkinson
Product Manager
Red Gate Software / comments
Thanks for the feedback.
1) This is a fair point. Could you describe a situation where you would want to just create the scripts? I suppose the option could be added to the File menu like it is in ...
Major versions will happily install side by side, so uninstalling shouldn't be necessary.
When a later version of SQL Compare is used on a previously created SQL Compare project (.scp files), it may render them unusable for previous versions of SQL Compare, so if there is a requirement for these to be used with the old version, make sure you copy your projects to a safe location.
If you've uninstalled an older version of our product and want it back, you can do so from the following web page: http://www.red-gate.com/supportcenter/G ... l_products\articles\old_versions.htm
David Atkinson
Red Gate Software / comments
Major versions will happily install side by side, so uninstalling shouldn't be necessary.
When a later version of SQL Compare is used on a previously created SQL Compare project (.scp files), it ma...
hbuckner wrote:
Can I compare the differences between two tables named differently in the same database?
Yes, simply go to the Remap Objects tab in the Edit Project dialog and use the Map and Unmap buttons.
Let us know if you have any trouble doing this.
Kind regards,
David Atkinson
Red Gate Software / comments
hbuckner wrote:
Can I compare the differences between two tables named differently in the same database?
Yes, simply go to the Remap Objects tab in the Edit Project dialog and use the Map and U...
SQL Compare has a new feature that works in conjunction with SQL Source Control. SQL migrations allows the user to add a custom script that overrides default behavior. http://www.red-gate.com/MessageBoard/vi ... 1312#51312
Let us know whether this meets your expectations.
David Atkinson
Red Gate Software / comments
SQL Compare has a new feature that works in conjunction with SQL Source Control. SQL migrations allows the user to add a custom script that overrides default behavior.http://www.red-gate.com/Messag...
No, it can't do this, but it's a problem we're aware of and it's very high on our list of candidates to be included in a later release.
Your last step of converting the column back to NOT NULL would surely fail as any pre-existing records in the target will have NULL in the new column and this is incompatible with changing it to NOT NULL.
The solution would have to be to allow the user to specify a default value for existing records in the target.
David Atkinson
Product Manager
Red Gate Software / comments
No, it can't do this, but it's a problem we're aware of and it's very high on our list of candidates to be included in a later release.
Your last step of converting the column back to NOT NULL woul...
Ah - I think I see what you mean. SQL Data Compare would have to be used to move the Data and if the schemas are different it wouldn't be able to deal with the additional column.
Therefore the schemas would need to be synched first in SQL Compare, which is not as data-aware as it could be so it will complain about the NOT NULL column. Ideally it should read the source table and spot that values for these additional columns already exist and use these.
In the meantime your best bet is to temporarily change the source column to be NULL, synch the schema using SQL Compare, synch the data using SQL Data Compare and set the source column back to NOT NULL. It's not as smooth as it should but hopefully we can improve matters in a later release.
Thanks for bringing this to our attention,
David Atkinson
Red Gate Software / comments
Ah - I think I see what you mean. SQL Data Compare would have to be used to move the Data and if the schemas are different it wouldn't be able to deal with the additional column.
Therefore the sche...