Comments
Sort by recent activity
Hi, thank you for your forum post. To answer your questions: Currently on v5.x and looking to go to v5.4.21 so we are 1 version behind the latest version. Is this do-able? Yes this is do-able. May I confirm the exact version you are upgrading from? If required, you can download SQL Clone V5.4.21.6521 using this link. PLEASE NOTE the link will expire on 16th August 2024. Extract the executable from the zip archive and run it on the machine that hosts your SQL Server. Follow the on-screen instructions. Also how does the agent get upgraded automatically? On upgrading the SQL Clone Server, each SQL Clone Agent will communicate and connect with the V5.4.21 server over port 14146. The Cone Server will detect that the Clone Agent connecting is on an earlier version and will attempt to automatically update the Clone Agent version by sending to it the single use SQL Clone Agent installer. Does the server that has the agent installed need to be internet facing? No the machine hosting a SQL Clone Agent does not need to be Internet facing, it simply requires a connection to the SQL Clone Server over port 14146. And is SQL Server 2012 still supported on v5.4.21 as we have a fair amount of SQL 2012 source and targets? SQL Server 2012 is still supported. You will find the requirements for both the SQL Clone Server and SQL Clone Agent in this help article. If you require any further assistance or encounter problems during the upgrade, please submit a support request, either by email - support@red-gate.com or via the support portable on the redgate web site and click the "Submit a request" option. Many Thanks Eddie / comments
Hi, thank you for your forum post.To answer your questions:Currently on v5.x and looking to go to v5.4.21 so we are 1 version behind the latest version. Is this do-able?Yes this is do-able. May I ...
Data Masker for SQL Server V7.1.46.8858 is now available that fixes this problem. The temporary table created by the shuffle rule, the column that the tool adds has been renamed and hopefully will not match any column name in the table to be masked. Many Thanks Eddie / comments
Data Masker for SQL Server V7.1.46.8858 is now available that fixes this problem. The temporary table created by the shuffle rule, the column that the tool adds has been renamed and hopefully will...
Hi TimothyO, I suspect that I have an open support ticket open with you, where we are waiting on a bug fix version of Data Masker. For other readers of this forum post. The problem is caused by Data Masker for certain rules, the shuffle rule is one example, a temporary table is created by SQL Data Masker. This temporary table is created with a column name ROW_ID, so SQL correctly errors as a table cannot have two columns with the same name. The good news is that a bug fix version is due to be made available. I will update this forum thread when the bug fix version becomes available. Many Thanks Eddie / comments
Hi TimothyO,I suspect that I have an open support ticket open with you, where we are waiting on a bug fix version of Data Masker.For other readers of this forum post. The problem is caused by Data...
Hi Jason_A, thank you for your forum post. Using this High Level Architecture diagram from our help documentation as a guide: [image] Are you referring to the NFS/SMB file share located in the middle of the diagram? Or the Database Backup location in the Production Environment on the left hand side of the diagram? For the cloning cluster (right side of the diagram) the backup files used to create the Cloning Data Images, need to be an accessible shared folder, which can be either an NFS or SMB file share. For NFS, NFS V3 and V4 are supported. For SMB, all versions of SMB are supported. The file share will be mounted into the application and the backup file will be read directly from there during the redgate Clone image creation operations. I hope the above helps. Many Thanks Eddie / comments
Hi Jason_A, thank you for your forum post.Using this High Level Architecture diagram from our help documentation as a guide: Are you referring to the NFS/SMB file share located in the middle of the...
Hi, thank you for your forum post. I believe that you also submitted a support ticket to us at Redgate. I am little confused by your message. I suspect you need to be using a Substitution Rule and select the Data Set that may have many values so that the same names do not keep appearing. Do the following help documents on getting started and substitution rules help you? Many Thanks Eddie / comments
Hi, thank you for your forum post.I believe that you also submitted a support ticket to us at Redgate.I am little confused by your message. I suspect you need to be using a Substitution Rule and se...
Hi Simon, I believe that you or a colleague also submitted a Support Ticket to us at Redgate. The problem was due to a loss of connection between the Clone Server and the Clone Agent that actually generates the Clone image. The entry in the dbo.Images table in the SQLClone_Config database was changed, so that the DeletedOn value was removed and set back to be a null value. Many Thanks Eddie / comments
Hi Simon,I believe that you or a colleague also submitted a Support Ticket to us at Redgate.The problem was due to a loss of connection between the Clone Server and the Clone Agent that actually ge...
Hi, thank you for your forum post. How many images have been created? The reason why I ask the question, I have seen previously on busy SQL Clone systems with large number of SQL Clone Agents deployed and a large number of images created, the SQL Clone UI / dashboard newer images fail to display as the maximum number of images that ca be displayed as been reached. Many Thanks Eddie / comments
Hi, thank you for your forum post.How many images have been created? The reason why I ask the question, I have seen previously on busy SQL Clone systems with large number of SQL Clone Agents deplo...
Hi, thank you for your forum post. I believe I provided this answer to you via a Redgate Support ticket as follows: To answer your question: I am just looking for clarification as to what this is deleting? From the screen shot: [image] The items successfully deleted items are all Clones. I come to this answer as icon to the left of the blacked out server name indicates a Clone. There is a different icon if an image was deleted or created, as per the example my screen shot below: [image] There are two methods for deleting clones (and images), the manual method via the Web UI and selecting the clone or image to delete. Or via an automation job using the PowerShell cmdlets to delete clones or images or both. Further information regarding SQL Clone can be found in the help documentation: https://documentation.red-gate.com/clone Plus there are Redgate University video courses to help you understand how to use SQL Clone: https://www.red-gate.com/hub/university/courses/sql-clone/introduction-to-sql-clone https://www.red-gate.com/hub/university/courses/sql-clone/unboxing-sql-clone/unboxing-sql-clone/unboxing-sql-clone https://www.red-gate.com/hub/university/courses/sql-clone/putting-together-logs-in-sql-clone/putting-together-logs-in-sql-clone/Logs Many Thanks Eddie Davis Senior Product Support Engineer / comments
Hi, thank you for your forum post.I believe I provided this answer to you via a Redgate Support ticket as follows:To answer your question:I am just looking for clarification as to what this is dele...
Hi, thank you for your forum post. During the comparison phase, Data Compare for Oracle does check upon the dependencies between tables it is comparing. So when generating the deployment script, the script should be generated in dependency order meaning that any data to be deleted in the target database/schema, the data TABLE2 would be deleted first and then deleted from TABLE1. / comments
Hi, thank you for your forum post.During the comparison phase, Data Compare for Oracle does check upon the dependencies between tables it is comparing. So when generating the deployment script, th...
Hi Rod, Thank you for your forum post. There is no command line or PowerShell cmd that will programmatically alter a MaskingSet's Rule Controller to point to a different database. You will need to edit the Rule Controller via the GUI, for the details of the new or different SQL Instance, select the Tools tab (in the Edit Rule Controller dialog refresh Tables and Indexes. Finally update the Rule Controller. Many Thanks Eddie / comments
Hi Rod, Thank you for your forum post.There is no command line or PowerShell cmd that will programmatically alter a MaskingSet's Rule Controller to point to a different database. You will need to ...