Work Around SQL Packager Retirement

muz

Hi there,

We bought a license to upgrade our SQL Data Compare from version 7 to version 13. 

All of the code involved in the upgrade has been completed, except for updating RedGate.SQLPackager.Engine.dll. I saw the retirement note of this dll in your website, so we decided to stick to the existing dll as recommended.

Having followed your recommendation though, we have another dependency issue - see below for more details:

Existing code:

        PackagerEngine engine = new PackagerEngine(

                   ......,

                   .......,

                   .......,

                   m_SchemaBlock,//of type RedGate.Shared.SQL.ExecutionBlock.ExecutionBlock

                   m_DataBlock,//of type RedGate.Shared.SQL.ExecutionBlock.ExecutionBlock

                   ......., 
                   .......);

Upgraded code:

        PackagerEngine engine = new PackagerEngine(

                   ......,

                   .......,

                   .......,

                   m_SchemaBlock,//of type RedGate.SQLCompare.Engine.IExecutionBlock

                   m_DataBlock,//of type RedGate.SQLCompare.Engine.IExecutionBlock

                   ......., 
                   .......);


As you may have already guessed, the upgraded code fails as the constructor of 'PackagerEngine' expect a variable of type RedGate.Shared.SQL.ExecutionBlock.ExecutionBlock, whereas the new upgraded code changes this to the new reference, which is RedGate.SQLCompare.Engine.IExecutionBlock.

Please let me know what your recommendation is to workaround this issue.

Kind regards, 
Muzafar Mahgoub