Comments
Sort by recent activity
Actually I should have mentioned, the best way to know when this is happening is to watch the user voice topic. http://redgate.uservoice.com/forums/174 ... tablenames / comments
Actually I should have mentioned, the best way to know when this is happening is to watch the user voice topic.http://redgate.uservoice.com/forums/174 ... tablenames
No the code was forked a long time ago and subsequently cleaned up.
Data Compare table mapping will be the next big feature to be added to the tool and in fact in theory the engine already supports it, I hope to have something ready sometime this year.
Richard
(currently concentrating on Git support in Source Control for Oracle and storage options in the Schema Compare engine) / comments
No the code was forked a long time ago and subsequently cleaned up.
Data Compare table mapping will be the next big feature to be added to the tool and in fact in theory the engine already supports...
That is exactly correct. For there to be a difference in the columns in the database the column must be made case-sensitive. There is the proviso that if the collations in the two databases differ we use the collation from the left hand database ( database1 in the API ) as there is no sensible way to compare two different collations together. This may in some circumstances produce strange results but as SQL Server doesn't allow this at all it's still
of benefit.
There will probably be an option introduced in a future version of the product that will force binary collation comparisons. This will mean that indexes can't be used but at least the result of the comparison will be predictable. / comments
That is exactly correct. For there to be a difference in the columns in the database the column must be made case-sensitive. There is the proviso that if the collations in the two databases differ ...
A lot of work has been performed on this version of data compare for better Collation compliance. In your table your schema says that the collation is case insensitive therefore there is no difference in the data from one to the other according to your own schema.
If in one database you have
"Data"
and in the other database
"data"
the two strings are the same according to the collation. If you wish for the data to be compared as different you need to set a case sensitive collation.
Hope this helps.
Richard Mitchell / comments
A lot of work has been performed on this version of data compare for better Collation compliance. In your table your schema says that the collation is case insensitive therefore there is no differe...
I've replied to you in a pm regarding your trial extension. / comments
I've replied to you in a pm regarding your trial extension.
You need to set primary keys or unique contraints on the tables to perform a comparison.
Hope this helps.
Richard Mitchell / comments
You need to set primary keys or unique contraints on the tables to perform a comparison.
Hope this helps.
Richard Mitchell
At the moment the best way to do this is to create an indexed view for the table and compare and synchronise using the view instead of the table.
Hope this helps.
Richard Mitchell / comments
At the moment the best way to do this is to create an indexed view for the table and compare and synchronise using the view instead of the table.
Hope this helps.
Richard Mitchell
I'll make sure this is considered as a feature for a future release.
Hope this helps.
Richard Mitchell / comments
I'll make sure this is considered as a feature for a future release.
Hope this helps.
Richard Mitchell
Any chance you could send us a screenshot of what you're seeing cut-off in Data Compare for Oracle.
I don't think it intentionally truncates values in the viewer - http://documentation.red-gate.com/displ ... g+the+data / comments
Any chance you could send us a screenshot of what you're seeing cut-off in Data Compare for Oracle.
I don't think it intentionally truncates values in the viewer - http://documentation.red-gate.com...
tahir wrote:
I use redgate's sqlazurebackup tool, and I'm facing the same error since today .I've also tried with the new version of the tool, same pb, don't now how to fix it [image]
I've just released a patch for SQL Azure Backup. You can either use the UI to download the 1.0.5 update or simply download the tool again from the website.
Hope this helps.
(Please direct future support for SQL Azure Backup to http://sqlazurebackup.uservoice.com) / comments
tahir wrote:
I use redgate's sqlazurebackup tool, and I'm facing the same error since today .I've also tried with the new version of the tool, same pb, don't now how to fix it
I've just rele...