User profile for Chris Spencer

Sorry I assumed C#. My knowledge of Vb.Net isn't the best but to my eyes your code should work. Interestingly when I disassembled my test assembly with Reflector and chose to display it as VB I got the following - mappings.Options = New EngineDataCompareOptions(MappingOptions.Default, ComparisonOptions.Default, (SqlOptions.ReseedIdentity Or (SqlOptions.UseTransactions Or SqlOptions.DisableKeys))) ...maybe my code was optimised by the compiler when I generated the assembly but it seems to use the logical Or rather than Xor. Personally I'd try the Xor first as this seems to work for me in c#. Regards Chris / comments

Sorry I assumed C#. My knowledge of Vb.Net isn't the best but to my eyes your code should work. Interestingly when I disassembled my test assembly with Reflector and chose to display it as VB I got...

0 votes

Hi You can achieve this by setting the TableMappings.Options in the following manner: mappings.Options = new EngineDataCompareOptions( MappingOptions.Default, ComparisonOptions.Default, SqlOptions.OutputComments ^ SqlOptions.OutputCommentHeader ^ SqlOptions.Default); You can see how I'm using the above code in the following program using System; using RedGate.SQL.Shared; using RedGate.SQLCompare.Engine; using RedGate.SQLDataCompare.Engine; namespace SQLDataCompareCodeSnippets { public class SqlProviderExample { public static void Main() { RunExample(); Console.Read(); } public static void RunExample() { Database db1 = new Database(); Database db2 = new Database(); db1.RegisterForDataCompare(new ConnectionProperties(".", "Test1"), Options.Default); db2.RegisterForDataCompare(new ConnectionProperties(".", "Test2"), Options.Default); // Create the mappings between the two databases TableMappings mappings = new TableMappings(); mappings.CreateMappings(db1.Tables, db2.Tables); // //Setup options so as to exlude the comment header and general comments from the scripts // mappings.Options = new EngineDataCompareOptions( MappingOptions.Default, ComparisonOptions.Default, SqlOptions.OutputComments ^ SqlOptions.OutputCommentHeader ^ SqlOptions.Default); using (ComparisonSession session = new ComparisonSession()) { // // Remember to set up the session options // session.Options = mappings.Options; session.CompareDatabases(db1, db2, mappings); // now get the ExecutionBlock containing the SQL // we want to run this on Test2 so we pass on true as the second parameter SqlProvider provider = new SqlProvider(); // // Also rememeber to set up the provider options // provider.Options = session.Options; ExecutionBlock block; try { block = provider.GetMigrationSQL(session, true); Console.WriteLine("The synchronization SQL contains {0} lines in {1} batches", block.LineCount, block.BatchCount); // if the ExecutionBlock was very large this could cause memory problems Console.WriteLine("The SQL to be run is:"); Console.WriteLine(block.GetString()); // we can access the SQL in a memory efficient manner by accessing the underlying stream // FileStream stream=block.GetFileStream(); // run the SQL ( commented out by default ) // BlockExecutor executor = new BlockExecutor(); // executor.ExecuteBlock(block, ".", "Test2"); } finally { block = provider.Block; if (block != null) { block.Dispose(); // dispose of the objects to delete temporary files } } } db1.Dispose(); db2.Dispose(); } } } Hope this helps Chris / comments

Hi You can achieve this by setting the TableMappings.Options in the following manner:mappings.Options = new EngineDataCompareOptions( MappingOptions.Default, C...

0 votes

Please check out my post on the Sql Data Compare 6 forum: http://www.red-gate.com/MessageBoard/viewtopic.php?t=5933 / comments

Please check out my post on the Sql Data Compare 6 forum:http://www.red-gate.com/MessageBoard/viewtopic.php?t=5933

0 votes

The Ignore case option only affects object mappings. Therefore if Ignore case is checked table db1.Customer is automatically mapped to db2.customer. If left unchecked on a case-sensitive server the tables will not be matched. It doesn't affect how data is compared. If you have case-insensitive databases and you wish to perform a case-sensitive comparison then the Force Binary Collation option would be better suited. This has been enhanced in Data Compare v6.0 to perform a case-sensitive comparison of data (in v5.3 it only deals with the comparison keys). Hope this helps Regards Chris / comments

The Ignore case option only affects object mappings. Therefore if Ignore case is checked table db1.Customer is automatically mapped to db2.customer. If left unchecked on a case-sensitive server the...

0 votes

Issues such as this do occasionally come up so your idea of a 'sloppy compare' option is a good one and one that we will consider adding in future versions. Thanks again for the excellent feedback. Regards Chris / comments

Issues such as this do occasionally come up so your idea of a 'sloppy compare' option is a good one and one that we will consider adding in future versions. Thanks again for the excellent feedback....

0 votes

Hi My guess is that you've activated SQL Data Compare with a standard license. Compare to backup is a pro license only feature. Hope this helps Regards Chris / comments

Hi My guess is that you've activated SQL Data Compare with a standard license. Compare to backup is a pro license only feature. Hope this helps Regards Chris

0 votes

Hi We also wouldn't want you to spend thousands for overpriced SQL Server editions which is why the professional version of data compare gives you access to a command line interface. An even more sophisticated alternative is to get a SQL Toolkit license and use the public API - this will allow you to schedule automatic comparisons/synchronizations directly from your code. Hope this helps Regards Chris / comments

Hi We also wouldn't want you to spend thousands for overpriced SQL Server editions which is why the professional version of data compare gives you access to a command line interface. An even more s...

0 votes

This sounds like a sensible idea although I'm unsure about the technical feasibility of doing this. However, it has been noted. We have attempted to make the backup schema retrieval as quick as possible and it should only take a matter of seconds. Out of interest how long is it taking for your backup? Regards Chris / comments

This sounds like a sensible idea although I'm unsure about the technical feasibility of doing this. However, it has been noted. We have attempted to make the backup schema retrieval as quick as pos...

0 votes

Charles, This definitely sounds like something isn't working as it should. To help us attempt to replicate this it would be useful to know the datatypes of the 2 fields in the key. Presumably the WHERE clause is filtering using both these fields. The more information you can give us the better. Regards Chris / comments

Charles, This definitely sounds like something isn't working as it should. To help us attempt to replicate this it would be useful to know the datatypes of the 2 fields in the key. Presumably the W...

0 votes

Thankyou very much for the feedback. Just to let you know that I've reproduced this issue on the alpha build and can confirm that it has subsequently been fixed ready for the final release Out of interest did you try out the new backup comparison functionality? Regards Chris / comments

Thankyou very much for the feedback. Just to let you know that I've reproduced this issue on the alpha build and can confirm that it has subsequently been fixed ready for the final release Out of i...

0 votes

How can we help you today?

Chris Spencer

Comments