Activity overview
Latest activity by BenjaminDS
Hello again Alex, Yeah, that's basically what I ended up doing. I have a python script acting as a 'pre-processor' now that converts all of the instances of the the 'alter proc' syntax in the files to 'create proc' and it looks like the compare is working now, so I don't think this is a deal killer just yet! Thanks again for all your help! / comments
Hello again Alex,Yeah, that's basically what I ended up doing. I have a python script acting as a 'pre-processor' now that converts all of the instances of the the 'alter proc' syntax in the file...
Hi Alex, Thanks so much for your response! We do have a standard practice of keeping individual stored procedure files in git in a format that does indeed use the 'alter procedure' syntax. Some preliminary testing indicates that this may well be what is happening. So, is there anything I can do to work with these files?? I noticed there is a 'change alter to drop and create' option in the SQL compare UI, but this appears to be just a setting for the scripts that are generated by SQL Compare. Is there any way to do something similar in the compare itself? rewriting all of out procedure definitions in source control may be a bit of a non-starter... Thanks again for your help! / comments
Hi Alex,Thanks so much for your response! We do have a standard practice of keeping individual stored procedure files in git in a format that does indeed use the 'alter procedure' syntax. Some pr...
sorry, should have specified this is SQL Compare version 13 / comments
sorry, should have specified this is SQL Compare version 13