Posts
Sort by recent activity
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...
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 ...
network name not found or not connect
Hi, I copied several Red Gate projects to a new server and put them on the drive. At first I was able to open and run them on my local instance of SQL Server, save the project, and then run them ...
Running a Post Script first when click Data Generate?
Hi, I suddenly have been running into a problem where when I click on "Generate Data" for the project, it tries to run the first Post Script instead of the PreScripts and it causes it to fail becau...
Using a weighted list in place of a FK.
Sometimes my FK is just a numbered list in a reference table. I wish sometimes to replace the FK with a weighted list so that it will be more realistic. It seems like sometimes the weighted list ...
Reference one column from a different database; reference one column from this database
Hi, I'm hoping there is some kind of answer to this. For my Red Gate project, my current table I tried to reference from a table in a different database. There are only two columns in this curren...