Activity overview
Latest activity by asadc
The issue was TCP/IP was not enabled. / comments
The issue was TCP/IP was not enabled.
Can't connect to SQL Server on localhost
I downloaded Flyway Desktop for Windows and tried to set the development database to localhost but kept on getting a 'Connection refused' error. I then manually updated the config file and it was a...
We're not using programmable objects, so the script that's generated will be a CREATE. I ended up manually modifying the generated script by adding a DROP, I'm not sure if there's a better way. = / comments
We're not using programmable objects, so the script that's generated will be a CREATE. I ended up manually modifying the generated script by adding a DROP, I'm not sure if there's a better way. =
It's a SQL Change Automation project. / comments
It's a SQL Change Automation project.
Adding a migration after a manual change to production
Hello,Could someone please advise on how to correctly sync the database project after a stored procedure was created manually in production? The project is currently configured to generate scripts ...
I'm also having an issue with the baseline script. I had an existing database in DEV, UAT and PROD. When I added the Redgate SQL project I selected DEV as the baseline. When I deployed to UAT I was expecting only the migration scripts to be executed given that the database already existed, but it executed the baseline script which meant changes were made that were not wanted. How can I avoid this problem? I only want the baseline to be executed if the database doesn't already exist. / comments
I'm also having an issue with the baseline script. I had an existing database in DEV, UAT and PROD.When I added the Redgate SQL project I selected DEV as the baseline. When I deployed to UAT I was ...