Comments
Sort by recent activity
Hi Craig,
Thanks for trying out the beta scripts folder functionality in Schema Compare.
For the time being we do not support pre-existing scripts. Given the complexity of Oracle DDL, we are focusing on understanding the syntax that Schema Compare outputs and ironing out any issues there first.
Are your existing scripts created by hand? by a previous version of Schema Compare? or something else?
Thanks,
Neil / comments
Hi Craig,
Thanks for trying out the beta scripts folder functionality in Schema Compare.
For the time being we do not support pre-existing scripts. Given the complexity of Oracle DDL, we are focusi...
Michael Newcomb wrote:
I'm having lots of problems with 10.2.0.696 (now upgraded to 10.2.0.777). SQL Compare is showing hundreds of differences between databases that have only minor changes -- if you click the "changed" items no differences show in the compare window.
Further, SQL Compare started popping a window that says it has "magically mapped the following fields." The mapping it shows makes absolutely no sense and seems random, but I can't figure out how to undo it or to stop it from doing anything magically.
Is there any way I can roll back to the old version? I can't use the product in its current state.
Thanks for your help,
Mike N.
Hi Mike,
Sorry about the problems you are experiencing. What sort of non-sensical mappings are you seeing? Can you give me the definitions of the tables please?
Are you able to send us snapshots of the databases which are showing invisible differences? If so please send them to support@red-gate.com
I believe the latest update has not been shipped in the installers on the site so if you uninstall Compare and download it again from http://www.red-gate.com/products/sql-de ... l-compare/ you can revert to the older version 10, just don't update it as yet.
Thanks,
Neil / comments
Michael Newcomb wrote:
I'm having lots of problems with 10.2.0.696 (now upgraded to 10.2.0.777). SQL Compare is showing hundreds of differences between databases that have only minor changes -- ...
DLDM wrote:
Hi, Neil,
I was seeing the same problem. I installed the patch and it fixed that particular problem.
However on a related note, the patch version still appears to be falsely reporting changes for some Stored Procedures that have not changed. Either there are differences that aren't being highlighted, or there aren't any differences and the SP should not have been flagged as changed.
-Dave
Hi DLDM,
Can you give me an example of a SP that you Compare is showing as different now?
Thanks,
Neil / comments
DLDM wrote:
Hi, Neil,
I was seeing the same problem. I installed the patch and it fixed that particular problem.
However on a related note, the patch version still appears to be falsely reporti...
Hi Skuhn,
Can you try the patch build from here: ftp://support.red-gate.com/patches/sql_ ... .0.777.zip
and let me know if it fixes your problem?
Thanks,
Neil / comments
Hi Skuhn,
Can you try the patch build from here:ftp://support.red-gate.com/patches/sql_ ... .0.777.zip
and let me know if it fixes your problem?
Thanks,
Neil
Hi ahribernik,
Thanks for your response. I'm still failing to reproduce the problem.
In your scenario are you using a saved project file from the previously released version of Compare? Does the problem persist if you create a new project or do a comparison without saving it as a project?
Thanks,
Neil / comments
Hi ahribernik,
Thanks for your response. I'm still failing to reproduce the problem.
In your scenario are you using a saved project file from the previously released version of Compare? Does the pr...
Hi ahribernik,
Sorry you are having a problem with Compare. I've been trying to recreate the issue you are reporting but to no avail.
I've tried with the following objects:
source
CREATE TABLE T1
(c1 int, c2 nvarchar(50) )
GO
CREATE NONCLUSTERED INDEX IX_INDEX_1
ON T1 (C2)
GO
and target
CREATE TABLE T1
(c1 int, c2 nvarchar(50) )
WITH (DATA_COMPRESSION = PAGE);
GO
CREATE NONCLUSTERED INDEX IX_INDEX_1
ON T1 (C2)
WITH ( DATA_COMPRESSION = PAGE ) ;
GO
and the ignore data compression option seems to work. Can you give me a specific example?
Thanks,
Neil / comments
Hi ahribernik,
Sorry you are having a problem with Compare. I've been trying to recreate the issue you are reporting but to no avail.
I've tried with the following objects:
source
CREATE TABLE T1
(...
Hi guys,
Sorry you are experiencing this problem. Can you please try the patch release of Compare here: ftp://support.red-gate.com/patches/sql_ ... .0.777.zip
and let me know if it fixes this problem for you?
Thanks,
Neil / comments
Hi guys,
Sorry you are experiencing this problem. Can you please try the patch release of Compare here:ftp://support.red-gate.com/patches/sql_ ... .0.777.zip
and let me know if it fixes this proble...
Hi,
To get the table schema you can run the following command SHOW CREATE TABLE tbl_name in a tool such as MySQL workbench.
Neil / comments
Hi,
To get the table schema you can run the following command SHOW CREATE TABLE tbl_name in a tool such as MySQL workbench.
Neil
Hi mmoore5553,
Sorry you didn't get a reply to your bug report, did you send it to the mysql mailbox mysql@red-gate.com?
The data comparison tool attempts to bring the two databases inline so by default it will try to drop data that is only in the target. At the comparison grid you need to uncheck the rows that are only present in the target in order to have MySQL Data Compare leave those rows alone.
Can you post the schema of the table you are comparing (`xf_cz_group_member`) here? I suspect there are multiple keys on that table and selecting an alternate one to use during the comparison might help.
FYI there are forums just for the MySQL tools: http://www.red-gate.com/MessageBoard/vi ... .php?f=119 http://www.red-gate.com/MessageBoard/vi ... .php?f=146
Regards,
Neil / comments
Hi mmoore5553,
Sorry you didn't get a reply to your bug report, did you send it to the mysql mailbox mysql@red-gate.com?
The data comparison tool attempts to bring the two databases inline so by de...
Hi jlu,
The previous reporter of the issue and I were not able to recreate the problem. Can you send us the schema of the tables you are comparing and the versions of the instances of MySQL please?
You can post the info here or send it to mysql@red-gate.com
Thanks for your report,
Neil / comments
Hi jlu,
The previous reporter of the issue and I were not able to recreate the problem. Can you send us the schema of the tables you are comparing and the versions of the instances of MySQL please?...