Table lock issues during upgrade from 2009 -> 2013

Hi All

Im currently attempting to upgrade a database from 2009R2 to 2017.

On the step where i upgrade the database from 2009 to 2013 by opening it in the development invironment im experiencing issues with table locks.
(this is the step where sql data types and colation is changed)

I have tried running the database in single user and multi user.

I have tried turning off all service tiers and taking all other databases offline. There are no maintenance or other sql jobs interfering with the upgrade.

Below i have attached some screenshots showing the problem.

rhffzrr6dmsw.png
q3skre3dxbjs.png
70n75bff6fbk.png

I have redacted the database and table names in the screenshots above due to my customers privacy.

However i think you get the idea.

Any ideas would be greatly appreciated - See you all at TechDays

Best Answer

Answers

  • AronChanAronChan Member Posts: 9
    Thank you Slawek. It was indeed the CDC messing with me.
Sign In or Register to comment.