This content has been marked as final. Show 2 replies
did you delete the views, procedures, functions etc. from the converted model only for the database where you have the problem, or did you do the same for all the three databases?
Have you had a look at the MIGRLOG table in your migration repository? Does it contain any helpful information?
I deleted the views, procedures, functions etc from the captured and converted model for all the databases.
I had a look at the MIGRLOG table and it helped identify my problem. On the problem remote database, the permission was set to data writer instead of data reader.
Thanks for your help