Comments
Sort by recent activity
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 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...
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, thank you for your forum post. May I ask what modifications you are looking to apply? It is possible to make modifications during the create Clone process, further reading in this help document. Better still, modify the image during the Image creation step, as per this help document. There is no configuration you can make to the SQL Clone Agent to prevent it from automatically attach to the Clone. Also, any modifications you make to the Clone post the creation of the Clone, will cause the differencing disk to inflate which may inflate to a size bigger that the original database, depending on what you are modifying. Many Thanks Eddie / comments
Hi, thank you for your forum post.May I ask what modifications you are looking to apply?It is possible to make modifications during the create Clone process, further reading in this help document.B...
Hi, Sadly there is no workaround. SQL Compare to my knowledge has never been tested for use with GCP. Many Thanks Eddie / comments
Hi,Sadly there is no workaround. SQL Compare to my knowledge has never been tested for use with GCP.Many ThanksEddie
Hi PMS, Thank you for your forum post. Unfortunately, SQL Compare does not support GCP. Therefore I am unable to provide instructions for using SQL Compare in GCP. Many Thanks Eddie / comments
Hi PMS, Thank you for your forum post.Unfortunately, SQL Compare does not support GCP. Therefore I am unable to provide instructions for using SQL Compare in GCP.Many ThanksEddie
Hi, @Max_Bench thank you for your forum post. Not sure that I understand your question. SQL Clone will create an Image of the source database. By either connecting directing to the live source database or from a backup file of source database. The SQL Clone Image is point-in-time copy of the source database. Once the Image is created, you can then create clone databases from the image on as many SQL Instances as required. The host machine for the clone requires an install of the SQL Clone Agent and the account provided to the SQL Clone Agent service will require read, write, modify permissions to the storage location of SQL Clone Image. This help document explains in further detail how SQL Clone works. Many Thanks Eddie / comments
Hi, @Max_Bench thank you for your forum post.Not sure that I understand your question.SQL Clone will create an Image of the source database. By either connecting directing to the live source datab...
Hi Arie, thank you for your forum post. By default, Schema Compare for Oracle will ignore all storage options. If you edit your Schema Compare for Oracle -> Select the Options tab -> Include storage section, no options are selected. Plus in the Ignore section system partitions and lob storage options are greyed out and disabled. If you select the following Include storage options: all storage options partitioning tablespaces The system partitions and lob storage options are then enabled in the Ignore section and the user can then choose to Ignore by checking the check box. If just the lobs and arrays Include storage option is selected. The lob storage option is enabled in the Ignore section and the user can then choose to Ignore lob storage by checking the check box. Does the above above answer your question? Many Thanks Eddie / comments
Hi Arie, thank you for your forum post.By default, Schema Compare for Oracle will ignore all storage options.If you edit your Schema Compare for Oracle -> Select the Options tab -> Include storage ...
Hi, Sorry for the delay in replying to this post. The reporting feature of SQL Backup does not generate reports for the restore jobs that have been performed. When choosing to generate a report as per this help article, it create data on the backup jobs only However, as you have spotted, when using the option to generate reports for multiple SQL Instances, the SQLBackupReportingDatabase that needs to be created, does include 3 tables for restore tasks. I am not sure as to why these 3 tables are created, I suspect that steps were taken in the past to enhance the reporting feature to include the restore jobs but the feature was never actually released and work on adding the feature ceased. Hence you cannot generate reports via the reporting feature available via the SQL Backup GUI. So as the tool only appears to add entries for failed restore jobs, not sure that this will help you. Many Thanks Eddie / comments
Hi,Sorry for the delay in replying to this post.The reporting feature of SQL Backup does not generate reports for the restore jobs that have been performed. When choosing to generate a report as p...
Hi, thank you for your forum post. Just to confirm you are referring to the reporting database created when generating reports for multiple servers, as per this help article? If the answer is yes, the reporting database only reports on backup history. There is no reporting mechanism for the restore process or jobs. Many Thanks Eddie / comments
Hi, thank you for your forum post.Just to confirm you are referring to the reporting database created when generating reports for multiple servers, as per this help article? If the answer is yes,...