Activity overview
Latest activity by BobF
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...
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...
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...
Command rule not working as expected
I've created several command rules which have worked and working as expected. Despite some strange issues with semi colons if I remember correctly.Now I've put in place a quite complex command rul...
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...
Sorry found the issue - https://documentation.red-gate.com/clone2/troubleshooting/common-issues/newtonsoft-json-jsonserializationexception-cannot-create-and-populate-list-type / comments
Sorry found the issue - https://documentation.red-gate.com/clone2/troubleshooting/common-issues/newtonsoft-json-jsonserializationexception-cannot-create-and-populate-list-type
Error message when running PowerShell Script
I am trying to run the following PowerShell comands PS C:\Users\AUser> Connect-SqlClone -ServerUrl 'http://SQLCloneURL/'
$Image = Get-SqlCloneImage -Name 'Test_Image'The error message I get is this...
Thanks for the reply "Just to help us, can you tell us the size of your datamasker file?" - 5mb "Regarding to reducing the datamasker file, theres no way of reducing it other than removing rules" - tried that then saved the updated datamasker file. The size did not significantly change only reduced by 10's of KB :-( / comments
Thanks for the reply"Just to help us, can you tell us the size of your datamasker file?" - 5mb"Regarding to reducing the datamasker file, theres no way of reducing it other than removing rules" - t...
Size of Data masker file
Having just upgraded to a new version of SQL clone. We are now up against a new issue A recent change means we are unable to upload datamasker files > 1mb in size. What is the technical reason fo...