Comments
Sort by recent activity
A. SQL Clone It's an amazing product! / comments
A. SQL Clone It's an amazing product!
Ok found the issue. There is a rule which Truncates data in a processing table, then repopulates the table with data. All the tasks use the data in that processing table. When I added some new command rules they were not dependant on the first step completing. So they ran the scripts against the processing table which had Zero records. The deletion scripts ran successfully as they use the records in the processing table to identify the records to delete. Yes Chris Unwin has done a nice video on setting up dependency in Redgate University. Which I will need to study some more, to see if I can set up the dependency as suggested. Today was another learning opportunity which hopefully I have gained some knowledge from. / comments
Ok found the issue. There is a rule which Truncates data in a processing table, then repopulates the table with data. All the tasks use the data in that processing table. When I added some new c...
Hi @Alex B thanks for the reply. Most of the Command Rules that I have created till now have been Script mode (I think). That is to say on the 'Options' tab select "Check for errors in every...." line, ending with a semicolon? The only significant change that I have made in my approach till now is to use a CTE to populate a temp table. I'm going to do some testing again this afternoon (hopefully) to see if I can reproduce the results I saw yesterday. / comments
Hi @Alex B thanks for the reply.Most of the Command Rules that I have created till now have been Script mode (I think). That is to say on the 'Options' tab select"Check for errors in every...." lin...
Ok after some testing I was able to reproduce the error [image] I have two commands, one check's for table existence, the next one creates a temp table. Then semicolonon and then a CTE. With the semicolon at the start of a the CTE statement is the issue. At least that's my assumption. I am going to re-write the script and see if it I can get it to work / comments
Ok after some testing I was able to reproduce the error I have two commands, one check's for table existence, the next one creates a temp table. Then semicolonon and then a CTE. With the semico...
Ok now I've found the underlying issue. This script is run from local machine, which does not have SQL Clone installed. The resolution seems to be to install the newtonsoft DLL on my machine, correct? / comments
Ok now I've found the underlying issue. This script is run from local machine, which does not have SQL Clone installed. The resolution seems to be to install the newtonsoft DLL on my machine, cor...