Activity overview
Latest activity by Eddie Davis
How the "Ignore constraint and index names" options differ
The "Ignore constraint and index names" option ignores the names of system generated and user-defined indexes, foreign keys, primary keys, and default, unique, and check constraints when comparing ...
SQL Search and SQL History show a blank screen on SSMS 22
If SQL History or SQL Search opens but shows a blank screen with nothing loading, check the SQL Search log files for the following entry:[Error] [RedGate.SQSearch.Addin.Utils]: Unhandled exception...
Hi David, Thank you for your update. Just to confirm, based on your screenshot. The left-hand data source is taht includes the DF_DBAmpTableOptions_Options and the DF_DBAmpTableOptions_SkipTable default constraints are from your your live SQL Server? And the right-hand source with just the DEFAULT keyword is a scripts folder of your Visual Studio project? What version of SQL Compare are you using? The live SQL Server database, what version of SQL Server is it hosted upon? / comments
Hi David,Thank you for your update. Just to confirm, based on your screenshot. The left-hand data source is taht includes the DF_DBAmpTableOptions_Options and the DF_DBAmpTableOptions_SkipTable ...
Hi, Thank you for your forum post. Can you please confirm the full version of Schema Compare for Oracle you are using? You can obtain this information via the Help menu →About option. The data sources are you comparing two databse schemas or Scripts folder as the source to a database schema as the target? Or database schema as the source to a Scripts folder as the target? What version of Oracle in use on the database schema you are comparing? Can you please enable the Verbose logging as per this help article. Are there any entries in the log file that suggest a possible cause of the error? / comments
Hi,Thank you for your forum post.Can you please confirm the full version of Schema Compare for Oracle you are using? You can obtain this information via the Help menu →About option.The data sources...
Hi Terry, You can set the deployment scripts folder via the Tools menu → Application options → Edit the Deployment scripts folder path. After editing the above when you next execute the deployment wizard, it will be the path configured within the application options. / comments
Hi Terry,You can set the deployment scripts folder via the Tools menu → Application options → Edit the Deployment scripts folder path.After editing the above when you next execute the deployment wi...
Hi, thank you for your support forum post. SQL Backup does not backup or restore directly to/from Azure Storage. The Cloud Storage Feature of SQL Backup simply allows an user to upload a copy of a backup file on successful completion of its creation to either Azure Storage or AWS S3 storage. If the need arises for an user to download from the Azure storage, this is a manual process where the user downs the backup file to a local disk. SQL Backup can then be used to perfrom the restore. Providing you configure the following options for your azure Government cloud and obtain a successful network connection:
Azure Storage Account Name
Azure Access Key
Blob Container Name
If selecting Custom Azure Storage - Custom Endpoint
SQL Backup will upload the backup file or files created. If there are additional options that need to be included to upload to azure Government cloud, then the answer will be no, as you will not be able to configure these options within SQL Backup. How to configure the Cloud Storage feature of SQL Backup is available in the following help documentation: https://documentation.red-gate.com/sbu/settings-and-options/cloud-storage-settings https://documentation.red-gate.com/sbu/settings-and-options/cloud-storage-settings/azure-blob-storage-backup https://documentation.red-gate.com/sbu/worked-examples/backing-up-to-cloud-storage-settings https://documentation.red-gate.com/sbu/tools-and-utilities/sqbhostedstorageclient-exe / comments
Hi, thank you for your support forum post.SQL Backup does not backup or restore directly to/from Azure Storage. The Cloud Storage Feature of SQL Backup simply allows an user to upload a copy of a ...
Hi Robert, Thank you for your forum post and sorry to read you had a difficult time deploying your database differences to the target database. Normally, SQL Compare will deploy objects in dependency order. So I am interested in knowing further details on what occurred when you attempted to deploy. What is the full version number of SQL Compare you are using? You can obtain this information from the GUI→Help menu →About option. If known or seen, where there any warnings generated on the Summary page of the deployment wizard? Many Thanks Eddie Davis Senior Product Support Engineer, Redgate Software Ltd / comments
Hi Robert,Thank you for your forum post and sorry to read you had a difficult time deploying your database differences to the target database.Normally, SQL Compare will deploy objects in dependency...
Hi Toni, Thank you for your replies. I perfectly understand your reply. The comment made one day ago is not from me, but by another party. A Redgate Product Support ticket has been created for you, the ticket reference number is 336689. Please check you mail inbox and / or your junk mail folder incase the message I sent gets trapped there. The email will be from support@red-gate.com. Many Thanks Eddie / comments
Hi Toni,Thank you for your replies. I perfectly understand your reply. The comment made one day ago is not from me, but by another party.A Redgate Product Support ticket has been created for you, ...
Hi Toni, Would it be possible to obtain a copy of the DDL for the table with the two filtered indexes? Also copy of the scripts file for the table from your scripts folder? Just to confirm, the scripts folder is the source and the deployment target is the database? As the deployment process when you deploy will remove the where clause, as the deployment will modify the database in this scenario so it matches the source scripts folder. The scripts folder, was it created from a different database? If yes, does the source database include the filtered indexes with the where clause? Many Thanks Eddie / comments
Hi Toni,Would it be possible to obtain a copy of the DDL for the table with the two filtered indexes? Also copy of the scripts file for the table from your scripts folder? Just to confirm, the sc...
Hi, Thank you for your forum post. Indexes and DML triggers are not treated as database object on their own. Indexes and DML triggers are included as being part of table, so the differences in your Indexes and DML triggers will be highlighted in the table differences during a comparison and the subsequent comparison results. / comments
Hi,Thank you for your forum post.Indexes and DML triggers are not treated as database object on their own. Indexes and DML triggers are included as being part of table, so the differences in your ...