Activity overview
Latest activity by Mij
Thank you for you quick responses though. / comments
Thank you for you quick responses though.
I haven't used Powershell. I'd have to see what to do with this. Basically, I open SSMS, drop the database, recreate the database, and then open the SCA project and see that there are 20 scripts to be applied. I click the "Apply/All" button. It errors on the later migrations because the baseline has not run to populate with tables and objects even though that is the first migration script. / comments
I haven't used Powershell. I'd have to see what to do with this. Basically, I open SSMS, drop the database, recreate the database, and then open the SCA project and see that there are 20 scripts...
As I said, I freshly dropped and created the database and then I tried to run the scripts. What else would you be looking for? If there are gMSA accounts or users that somehow came back, would that affect it? I haven't added anything to the database after I recreated it. / comments
As I said, I freshly dropped and created the database and then I tried to run the scripts. What else would you be looking for? If there are gMSA accounts or users that somehow came back, would th...
I guess I should say that the baseline script is the first script in the Migrations folder as folder 1.0.0-Baseline with just that one item. / comments
I guess I should say that the baseline script is the first script in the Migrations folder as folder 1.0.0-Baseline with just that one item.
Scripts not running/ or not in order?
Hi, I went back to an older SQL Change Automation project that I thought was running last time. I had tried to turn off programmable objects because they are included in the baseline and the migra...
I appreciate your advice. I am including the screenshot, but this time while I was taking the screenshot, the project came up and allowed me to change settings to update the project. I will keep that in mind that in future I could open in a text editor - I hope that may be helpful in the future.[image] / comments
I appreciate your advice. I am including the screenshot, but this time while I was taking the screenshot, the project came up and allowed me to change settings to update the project. I will keep ...
Project from 6 months ago not loading now
I have two Red Gate data generation projects. One will not load at all, it says that my login failed for that database. I need to open it and change the database server and settings. The second ...
Our Systems Architect discovered the issue. He read the error message that gets sent to Red Gate. We discovered that where initially I had set up the projects and imported the scripts from a network folder, occasionally I had trouble with the network folder disconnecting so I moved copies of the projects to the local drive on my dev servers. Our architect found that the project was still trying to reference the imported scripts from the network shared drive instead of the local drive and that was causing the "network name cannot be found" error. Once I went to the project on the network folder and deleted all the scripts, then re-imported them into the local project (that I had copied over again) from the local folder, then the projects began working again and I had no issue when clicking the 'Edit Project...' button. / comments
Our Systems Architect discovered the issue. He read the error message that gets sent to Red Gate. We discovered that where initially I had set up the projects and imported the scripts from a netw...
This is happening with the same data generator project on two different servers with two different SQL instances. / comments
This is happening with the same data generator project on two different servers with two different SQL instances.
This time the problem was that I could not connect to my SQL instance on that AWS DEV server. Now that is fixed and I can again load the first two projects but when I click on "Edit Project..." they again say "network name not found" and error and close. I was able to start a new project on a new database and save it, then click on "Edit Project..." and it opened the SQL instance and database and had script and options. I'm not sure what is wrong with the first two projects or if I will have to recreate them. That could take a fair amount of effort. / comments
This time the problem was that I could not connect to my SQL instance on that AWS DEV server. Now that is fixed and I can again load the first two projects but when I click on "Edit Project..." th...