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

Work Around SQL Packager Retirement

muzmuz Posts: 6 New member
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
Tagged:
Sign In or Register to comment.