Comments
Sort by recent activity
Hi, thank you for your forum post. The help documentation listed below, only has examples for a PK of one column and not multiple columns. They may provide some assistance to you, as the steps to take will be identical or similar for multi column PKs: Sync Manager Rules Change a PK value and all associated FKs FK Refresh Rules You will need the Sync. Manager rule on each of the Child tables, as a substitution rule requires a PK. Otherwise, this subject will require a support ticket to investigate further as the subject is too complex to handle via this forum. Many Thanks Eddie / comments
Hi, thank you for your forum post.The help documentation listed below, only has examples for a PK of one column and not multiple columns. They may provide some assistance to you, as the steps to t...
Hi, thank you for your forum post. In the TDM Anonymizer you can choose different or custom datasets. This help document explains how to define a custom dataset. Many Thanks Eddie / comments
Hi, thank you for your forum post.In the TDM Anonymizer you can choose different or custom datasets. This help document explains how to define a custom dataset.Many ThanksEddie
Hi BenDAltus, Thank you for your forum post. Does the information in this help document, help to answer your question? The document includes information on the Support database systems and capabilities of the tools within Test Data Manager. Many Thanks Eddie / comments
Hi BenDAltus,Thank you for your forum post.Does the information in this help document, help to answer your question?The document includes information on the Support database systems and capabilitie...
Hi Khaoula, Thank you for your forum post. For substitution rules requires that the table to be masked has a primary key, as per the second sentence in this help document. First introduced in V7.1.32, on creating a substitution rule on a table with no primary key, an Invalid Rule dialog appears, as per the image below: [image] You simply need to click Convert to sync manager button. This converts the substitution rule to become a Sync. Manger rule.
The Sync Manager rule creates a temporary table that is a copy of the table selected in the substitution rule, with one difference in that it has a primary key constraint.
It populates the data from the live table into the temporary table.
Runs the substitution rule against the temporary table.
Using a Table to Table rule copies the masked data from the temporary table to the live table you originally selected for the substitution rule that has no primary key.
Finally drops the temporary table.
No requirement for the command rules to create a Primary Key and Indexes. Although what you have configured will add the Primary key for the tables with no primary key, the Rule Controller is not freshed, so is still working on the fact there is no Primary Key. The conversion of each substitution rule whose table has no primary key, the conversion to Sync. Manager rule is the solution in your scenario. Many Thanks Eddie / comments
Hi Khaoula,Thank you for your forum post.For substitution rules requires that the table to be masked has a primary key, as per the second sentence in this help document.First introduced in V7.1.32,...
Hi emmar00, Thank you for your forum post. Please drop the left behind SqlCloneTemp databases, as everything looks healthy. On the next occasion it occurs, it would be good to check both the SQL Clone Server and the SQL Clone Agent log files to see why the SqlCloneTemp database did not successfully dropped. In my experience, it is some process preventing the database from being dropped or the temporary user created to perform any modification to an image can't be dropped as it still owns an object. Many Thanks Eddie / comments
Hi emmar00,Thank you for your forum post.Please drop the left behind SqlCloneTemp databases, as everything looks healthy.On the next occasion it occurs, it would be good to check both the SQL Clone...
Hi unclepuff, thank you for your forum post. If you locate the SQL Data Masker log file for this failed masking attempt, does it reveal any further information? The log file location can be found the SQL Data Masker GUI ->Misc. Setup tab ->Directories tab ->the path to log file is list under Directory for Log Files. Or if using the command line, you will find the log file in the path specified in your PARFILE for the LOGFILEDIR= parameter. Just to confirm, this is one substitution rule that is masking 50 columns in one table? Or you are masking 50 columns in this one table spread over two or more substitution rules? I ask this question, as if you have a single rule, you will most likely encounter performance errors. Please consider splitting the rule in smaller more manageable chunks, further reading here. Check the rule particularly the VARCHAR and CHAR columns in that the data set selected is not going to insert a text string that excludes the length of the column. Many Thanks Eddie / comments
Hi unclepuff, thank you for your forum post.If you locate the SQL Data Masker log file for this failed masking attempt, does it reveal any further information?The log file location can be found the...
Hi, thank you for your forum post. Not exactly, if you create a substitution rule on one table and mask the date/time column with the dates, random masking set. You can then use Table-To-Table Sync rule to update the date/time column in another table. Many Thanks Eddie / comments
Hi, thank you for your forum post.Not exactly, if you create a substitution rule on one table and mask the date/time column with the dates, random masking set. You can then use Table-To-Table Syn...
Hi, thank you for your forum post. Sadly I do not have a good answer to your question: Can I look for data types and mask across multiple tables? As both solutions will require some work. Worst case scenario, Data Masker will require a Masking set for each database. You can create the first masking set on database_1. Make a copy and save as a different name, then edit the Rule Controller connection details to point to database_2 and then save the changes. Repeat for each database as required. Alternatively, create the masking set on database_1 generating the substitution rules on the tables in database_1. Once you are happy with the rules created, next create Cross Database Table-to-table rules to then copy the masked data from database_1.Table1 to database_2.Table1 and so on. Make each Cross Database Table-to-table rule dependent on the substitution rule running against the table in Database_1. Further information on Cross Database Table-to-table rules can be found here. Likewise information on setting rule dependencies are in this help article. Many Thanks Eddie / comments
Hi, thank you for your forum post.Sadly I do not have a good answer to your question:Can I look for data types and mask across multiple tables?As both solutions will require some work.Worst case sc...
Hi andrewgibson, thank you for your forum post. "The operating system returned error 21" errors indicates a networking problem with the Clone database (SQL Clone Agent) losing its connection to the Clone Image. Has there been any network outages between the machine hosting the Clone and SQL Clone Agent service to the machine hosting the network share where the SQL Clone Image resides? Many Thanks Eddie / comments
Hi andrewgibson, thank you for your forum post."The operating system returned error 21" errors indicates a networking problem with the Clone database (SQL Clone Agent) losing its connection to the ...
Hi ab12, thank you for your forum post. To reply to this comment: I'm not sure neither what is this database created automatically. SQL Clone when creating a SQL Clone Image from a backup file and /or applying data masking to an image, the process creates a temporary database to restore the backup file into. I suspect the issue reported here: 2024-09-27 16:32:16.250 +02:00 [Warning] Failed to detach database "SqlCloneTemp_cekvf232", falling back to hard detach Microsoft.Data.SqlClient.SqlException (0x80131904): Cannot drop the database 'SqlCloneTemp_cekvf232' because it is being used for replication. The source database is configured to use SQL Server Replication features. So when the process completes, SQL Clone cleans up to remove the temporary database and cannot due to the SQL Server Replication configured. Sadly SQL Clone was never tested on databases using SQL Server Replication technology. I suspect that you will need to manually drop the temporary database created. Many Thanks Eddie / comments
Hi ab12, thank you for your forum post.To reply to this comment:I'm not sure neither what is this database created automatically.SQL Clone when creating a SQL Clone Image from a backup file and /or...