Red Gate forums: SQL Data Compare Previous Versions

uninstall red-gate bundle old version

myalo — Mon, 18 Mar 2013 00:50:38 GMT

I would to totally uninstall SQL compare v 3, DTS v 1.2 data compare 3.2
Add remove program don't show any of these program. The program files directory doesn't have any uninstall program.
Thanks for you help

RE: FieldMapping not valid for MatchingMappings

redkev — Thu, 07 Mar 2013 20:31:33 GMT

We were receiving the same error and found that it was due to a single table that had changed schema and the comparison file no longer could reconcile the mappings. To fix, you can open the .sdc file in a text editor (I recommend Notepad++) and cut out the bad table nodes. Then you can open the file in RedGate, re-select the table, and re-compare. Hope this helps!

Thanks,
Kevin

RE: Problems With Unicode When synchronizing Databases

Anu Deshpande — Wed, 06 Feb 2013 16:03:05 GMT

No problem! Thanks for the update!!

RE: Problems With Unicode When synchronizing Databases

iodissei — Wed, 06 Feb 2013 15:24:07 GMT

Much thanks for response! We've already done workaround for our task and have no opportunity to get debug info. If we have such problem in future, I've write to this post.

RE: Problems With Unicode When synchronizing Databases

Anu Deshpande — Wed, 06 Feb 2013 11:32:12 GMT

Thanks for your post.

I have logged a support call (F0069307) for you and emailed you with few suggestions.

Problems With Unicode When synchronizing Databases

iodissei — Tue, 05 Feb 2013 10:53:03 GMT

Synchronization fails when Unicode symbols are present.

Version: SQL Data Compare 9.0.0.117
Checked project options:
Mapping Behavior:
- ignore spaces in object names;
- include identity columns;
- include timestamp columns;
Comparison Behavior:
- show identical values in results
Synchronization Behavior:
- disable foreign keys;
- drop primary keys, indexes, and unique constraints;
- disable DML triggers;
- disable DDL triggers;
- include comment header in the synchronization script;

Thanks a lot!

RE: FieldMapping not valid for MatchingMappings

tschlarm — Mon, 23 Jul 2012 20:52:27 GMT

This error is still present in 10.2.0.315.

RE: Output char buffer is too small

Bastiaan Molsbeck — Tue, 29 May 2012 15:23:36 GMT

But when using version 10.0 of the SQL Data Compare Engine, the error does NOT occur! The migration SQL script is generated successfully.

Problem solved!

RE: Output char buffer is too small

Bastiaan Molsbeck — Tue, 29 May 2012 13:03:24 GMT

No, the field does not contain corrupt data.
Do you have any other suggestions?

Edit: when using version 9.0 of the SQL Data Compare Engine the same error occurs, but with a slightly different stacktrace:

System.ArgumentException: The output char buffer is too small to contain the decoded characters, encoding 'Unicode' fallback 'System.Text.DecoderReplacementFallback'.
Parameter name: chars
at System.Text.Encoding.ThrowCharsOverflow()
at System.Text.Encoding.ThrowCharsOverflow(DecoderNLS decoder, Boolean nothingDecoded)
at System.Text.UnicodeEncoding.GetChars(Byte* bytes, Int32 byteCount, Char* chars, Int32 charCount, DecoderNLS baseDecoder)
at System.Text.DecoderNLS.GetChars(Byte* bytes, Int32 byteCount, Char* chars, Int32 charCount, Boolean flush)
at System.Text.DecoderNLS.GetChars(Byte[] bytes, Int32 byteIndex, Int32 byteCount, Char[] chars, Int32 charIndex, Boolean flush)
at System.Text.DecoderNLS.GetChars(Byte[] bytes, Int32 byteIndex, Int32 byteCount, Char[] chars, Int32 charIndex)
at RedGate.SQLDataCompare.Engine.ResultsStore.Reader.#tN(FieldType type, BinaryReader reader, Boolean summary)
at RedGate.SQLDataCompare.Engine.ResultsStore.Reader.#ceL(FieldType fieldType, BinaryReader reader, Boolean summary)
at RedGate.SQLDataCompare.Engine.ResultsStore.Reader.#beL(BinaryReader reader, Boolean summary)
at RedGate.SQLDataCompare.Engine.ResultsStore.Reader.#deL(Object[] values, RowType& rowType, BinaryReader reader, FieldPairs fieldPairs, List`1[] types, Boolean summary, Byte[]& rowDifferences)
at RedGate.SQLDataCompare.Engine.ResultsStore.Reader.GetRow(BinaryReader reader, Int32 valuesCount, Int32 currentIndex, Int64 currentOffset, FieldPairs fields, List`1[] types, Boolean summary)
at RedGate.SQLDataCompare.Engine.ResultsStore.StoreEnumerator.MoveNext()
at #8ZK.#n2K.#QeL(#x1K writer, TableDifference summary, Reader rs, RowType resultsStoreType, Boolean runOnTwo, ProgressPercentageTracker progress, SelectionDelegate select, Boolean showComments)
at RedGate.SQLDataCompare.Engine.SqlProvider.#DbL(ComparisonSession session, SelectionDelegate select, Boolean runOnTwo)
at RedGate.SQLDataCompare.Engine.SqlProvider.GetMigrationSQL(ComparisonSession session, SelectionDelegate select, Boolean runOnTwo)
at RedGate.SQLDataCompare.Engine.SqlProvider.GetMigrationSQL(ComparisonSession session, Boolean runOnTwo)

RE: SQL Data Compare 9 - Only sync the last X months of data

Chris Auckland — Wed, 09 May 2012 09:24:09 GMT

Yes, you can add a SQL 'where' clause to each table, to filter the data you're synchronizing. You can configure this on the 'Tables & Views' tab.

See here for more info.

I hope this helps.

SQL Data Compare 9 - Only sync the last X months of data

brian.chiu.rt — Tue, 08 May 2012 00:12:45 GMT

With SQL Data Compare 9, is it possible to only sync the last 3 months of data for certain tables?

We want to use Data Compare to do a data extract weekly and for some tables we only wants the last 3 months worth of data.

Is this something that is doable with SQL Data Compare 9?

Thanks,
brian

RE: Possible bug: @PV variable declaration.

vasper — Fri, 30 Mar 2012 12:21:31 GMT

We are having the same problem with our upgrade scripts. We run them through the exes created by SQL Packager V6 ( 6.4.0.8 ).

It seems to be related with large volume of binary data being updated and for some reason the variable looses scope in the next statement.

Please find a fix because it takes 2 days to check and fix the amount of scripts we need, by trial and error.

Also as smarter aproach for deletes would be to delete consecutive rows that have integer primary index by range and not one by one.

RE: SQL Data Compare 9 - Comparing Different Datatypes

edrobny — Thu, 08 Mar 2012 19:31:56 GMT

I received the following response from support:

Quote:

Thank you for your support request and thank you for bringing this issue to our attention.

I was able to replicate the issue using SQL Data Comnpare v9.1.0.365 and the new V10.0.1.119

I suspect that the documentation is incorrect and the product is working correctly, as personally I would not expect that you would be able to match nvarchar datatype to numeric datatype.

I have submitted a bug report to the SQL Data Compare Development Team to bring this issue to their attention. The reference for this bug report is SDC-1325.

Once again, thank you for bringing this issue to our attention. Sadly, I do not have a work around for the issue to offer at this time.

SQL Data Compare 9 - Comparing Different Datatypes

edrobny — Wed, 07 Mar 2012 18:52:46 GMT

I am trying to compare several different datatypes, such as nvarchar to numeric. I checked the table from the link below and it is a supported data type comparison but SQL Data Compare says it is not. Here is a sample of what I am talking about.

Any help would be much appreciate.

http://www.ericdrobny.com/sites/default/files/public/SQLDataCompare.jpg

http://www.red-gate.com/supportcenter/content/SQL_Data_Compare/help/9.0/SDC_Which_Data_Types_Can_Be_Compared

RE: SQL Data Compare 8.1.0.4 generates script with syntax errors

Adam Hodge — Tue, 06 Mar 2012 13:54:33 GMT

Thanks for sharing the info with us! Just what need! I have the same problem with 9.0.0.117.