0

I am trying to migrate a database from 2016 to 2014 through Task-->Generate Scripts. There are some stored procedures that are locked and seems like they are encrypted as well. They are causing error while generating the script. I have tried both schema or schema and data.

I have also tried using Task--> Export Data tier application but that is generating error related to logins.

Looking for an advice in terms of best way to do this or how to fix the above errors. Thanks in advance.enter image description here

user2664231
  • 1

1 Answers1

0

The only thing you can do - skip such procedures.

If you have a source code for this procedure somewhere in your repositories and/or archives - good, take it from there. If not - alas, you will not be able to migrate it.

White Owl
  • 1,029
  • 3
  • 9