What are the challenges you face when working across database platforms? Take the survey

Problems encountered with Data compare

r.leo@cesop.itr.leo@cesop.it Posts: 4
edited October 5, 2011 9:00AM in Data Compare for Oracle
I am interested to your software and I've downloaded it and i'am trying it for my company. I find different troubles and I'd like to know if there are solutions for it (service pack, workarounds etc....):

1. The comparison of data for almost all the tables worked except for a table for rows that had the same primary key: Red Gate software didn’t make a UPDATE statement but it did the INSERT statement and then the DELETE statement. For this table, the INSERT statement did not work because the it caused primary key violation error.
2. If I select in the Application Options the ASCII encoding, and I generate the SQL script when I save the file, the character '°' and accented characters are replace dy '?'. Instead, after clicking on 'Deployment wizard' in the preview window of the script, if I click on the button 'Copy to clipboard' and paste the content in a text editor (Notepad++ for example) the problem does not occur. The character '°' should be seen correctly if I create a file with ASCII encoding: I did a test with the GNU editor Notepad++ and it’s so.
3. When I change the direction of the arrow under the application and menu bars (using the context menu voice ‘Switch deployment direction’) the arrow change direction (and it’s correct) but the schema names to the left and to the right of the arrow get reversed and change the position: I think that this last behavior it isn’t correct; in Sql Compare and Data Compare for Microsoft Sql Server the arrow change direction but the schema names don’t change position.
Sign In or Register to comment.