CreateMappings with SQLCompare 6.0.0.928

rickybibi

Why this code doesn't working anymore with the SQLCompare 6.0.0.928 ?

                databaseData.RegisterForDataCompare(new ConnectionProperties(servername, databasename), Options.Default);
                databaseData2.RegisterForDataCompare(new ConnectionProperties(servername, databasename2), Options.Default);

                using (ComparisonSession session = new ComparisonSession())
                {
                    TableMappings tableMappings = new TableMappings();

                    tableMappings.Options = dataOptions;

                    //
                    // Create the mappings. (Nb. only want tables. should not package data in views
                    //
                    tableMappings.CreateMappings(databaseData.Tables, databaseData2.Tables);

Y receive this error message .


System.MissingMethodException was unhandled
Message="Method not found: 'Void RedGate.SQLCompare.Engine.Mappings.CreateMappings(RedGate.SQLCompare.Engine.SerializableCollection, RedGate.SQLCompare.Engine.SerializableCollection, System.Object, Boolean)'."
Source="RedGate.SQLDataCompare.Engine"
StackTrace:
at RedGate.SQLDataCompare.Engine.TableMappings.CreateMappings(Tables in1, Tables in2)


Please HELP

Michelle T

The current v6 version of the toolkit is only for SQL Compare-based operations. Your code uses RegisterForDataCompare, which is a SQL Data Compare-based operation. For Data Compare operations, you will need to use the v5 version of the toolkit. A v6 version of the Data Compare components is under development, but is not yet released.

rickybibi

So you said .
I cannot make a Packages(Schemas + Data) with SQlPackage 5 because i'm using SQLCompare 6 !!!

Michelle T

That's unfortunately correct - we haven't updated the Packager functionality to v6 yet, so if you want to make a package you will have to use v5 throughout.