Activity overview
Latest activity by lkeith
I was looking at this page, https://www.red-gate.com/supportcenter/ ... Exit_Codes
which includes codes only up to 73. / comments
I was looking at this page,https://www.red-gate.com/supportcenter/ ... Exit_Codes
which includes codes only up to 73.
I have resolved on part of the issue; the DB being synched did not exist at the time. But I would like to know where I could have found any explanation for a return code of 126 or any other code. / comments
I have resolved on part of the issue; the DB being synched did not exist at the time. But I would like to know where I could have found any explanation for a return code of 126 or any other code.
Error: No process is on the other end of the pipe
I am using SQL Compare 8. When trying to synch a script repository with a SQL DB I am getting this:
Comparing database Scripts.Rex with database Rollout.rex_beta_dev...
Registering data sources
Err...
Thanks, David! Everything worked great. Now instead of modifying the sproc file in the repository and comitting to source control, I changed the SP in the DB then used SQLCompare to move the changes to the scripts repository then simply comitting to source control! Much more straigtforward.
SQLCompare adds some SQL directives at beginning & end of all sproc scripts and all scripts are CREATE, not ALTER. I had to manually add this to each script I put in the repository. Now I don't have to do that since SQLCompare will now.
Thanks again! / comments
Thanks, David! Everything worked great. Now instead of modifying the sproc file in the repository and comitting to source control, I changed the SP in the DB then used SQLCompare to move the change...
I want to do this because I am making a change to an SP from a custom utility outside the usual source control and want to commit it to source control so everyone will get the changes. / comments
I want to do this because I am making a change to an SP from a custom utility outside the usual source control and want to commit it to source control so everyone will get the changes.
Committing a sproc change with command line
I have made a change to an sproc in a db not linked to source control (but I could if necessary).
I would like to commit the sproc change to source control using a command line interface.
Is this p...