'Import and generate script' weird behavior
RomanPekar
Posts: 19 Bronze 1
After update from ReadyRoll to SQL Change Automation I see very weird behavior of 'Import and generate script' button. So when I press the button, nothing happens (visually) and interface stays responsive - so I can press the same button again or check / uncheck different objects. I've tried to wait for a long time (~2-3 minutes) and still nothing happens.
But then if I press 'Refresh' button suddenly I see new migration script in the solution explorer and see the dialog with 'refresh script'/'delete script' buttons.
Even worse, sometimes after I press 'refresh script' button the object which was changed by migration do not change inside 'Schema-model' folder, and only change when I press 'refresh' button again.
This was never the case with ReadyRoll, we were using 1.16 version.
I've tried to recreate this issue several times and I must say - this behavior is not very stable. So sometimes migration script is created quickly but then I have to wait for around 1-2 minutes before dialog with 'refresh script'/'delete script' appears.
But then if I press 'Refresh' button suddenly I see new migration script in the solution explorer and see the dialog with 'refresh script'/'delete script' buttons.
Even worse, sometimes after I press 'refresh script' button the object which was changed by migration do not change inside 'Schema-model' folder, and only change when I press 'refresh' button again.
This was never the case with ReadyRoll, we were using 1.16 version.
I've tried to recreate this issue several times and I must say - this behavior is not very stable. So sometimes migration script is created quickly but then I have to wait for around 1-2 minutes before dialog with 'refresh script'/'delete script' appears.
Tagged:
Answers
What version of Visual Studio and SQL Change Automation are you on? Also, what specific version of ReadyRoll 1.16 were you on?
Do the solution only contain a database project, or is there more than one db project or a mix of db and non projects?
If you create a new project using SQL Change Automation do you see the same behavior or is it only for projects updated from ReadyRoll?
Kind regards,
Alex
Have you visited our Help Center?
The solution only contain one project which is database project
It´s happening on both new and converted projects
Can you please update to the very latest version released today (version 3.0.18283.1889 - download here) and reproduce the issue? In this verison there is more logging which will be located at:
That will hopefully help shed some light on things. I'll create a ticket for you and email you shortly so you can reply to that message with the log file when you have it.
Kind regards,
Alex
Have you visited our Help Center?
It seems this issue has been resolved by the steps in this forum post:
https://forum.red-gate.com/discussion/84126/insanely-slow-refresh-functionality#latest
Kind regards,
Alex
Have you visited our Help Center?