Comments
Sort by recent activity
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...
Thank you for you quick responses though. / comments
Thank you for you quick responses though.
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.
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 ...
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...
These first two projects I began several versions of SQL Data Generator ago but they were working ok up until the recent version. / comments
These first two projects I began several versions of SQL Data Generator ago but they were working ok up until the recent version.
Now it will not even load the first time when I say "Open Project...". [image] / comments
Now it will not even load the first time when I say "Open Project...".